On 04:58 PM 5/10/2002 -0500, Miguel Cruz wrote:
>But he's dealing with cases where the company name remains the same but
>other data in the row changes (for instance, a company with multiple
>offices, where you wanted to list the phone number and address for each).
>GROUP BY would discard that oth
Miguel Cruz wrote:
> On Fri, 10 May 2002, Austin Marshall wrote:
>
>>>This not only takes care of the table row colors, but also removes
>>>duplicate company names so it looks MUCH neater this way :
>>
>>Is there not a GROUP BY clause in MS SQL? I'm pretty sure there is. If
>>you group th
On Fri, 10 May 2002, Austin Marshall wrote:
>> This not only takes care of the table row colors, but also removes
>> duplicate company names so it looks MUCH neater this way :
>
> Is there not a GROUP BY clause in MS SQL? I'm pretty sure there is. If
> you group the query by company name
Glenn Sieb wrote:
> Hey everyone!
>
> Thanks for all the hints--here's what my boss and I eventually came out
> with:
>
> /* ##
> ## And for every row of data we pull, we create a table row...
> ## */
> $company = 0;
>
4 matches
Mail list logo