Subject | Why won't Group By work? |
---|---|
Author | Adrian Wreyford |
Post date | 2005-11-26T10:42:28Z |
I have a table Rainfall with fields:
Rainfallid
RainfallZone
Rainfall
RainfallDate
Select * from Rainfall
Group by Rainfallzone
Get Error:
Invalid expression in the select list(Not contained in either an aggregate
function or group by clause)
Thanks Adrian
[Non-text portions of this message have been removed]
Rainfallid
RainfallZone
Rainfall
RainfallDate
Select * from Rainfall
Group by Rainfallzone
Get Error:
Invalid expression in the select list(Not contained in either an aggregate
function or group by clause)
Thanks Adrian
[Non-text portions of this message have been removed]