At 09:42 PM 15/08/2010, Hardy , wrote:

>Hi Helen, What does group by 1 means in your select statement below ?
>
>>select sls_id, sum (amount)
>>from SaleRevenue
>>Where region = 'West'
>>group by 1
>>

It means "first field in the grouping list". For this query it could be substituted by

group by sls_id

...but it is not true that the field name can be used in all cases.

HB