Hi all,
I m getting an error while using groupby
the error is "Column is nt used as a group identifier"

Hi,

On what line of code is this error?
Can you please post a screen shot of the error?

- George

Sir,
The error is cuming on the compilation window

If you have a group by, all fields in the group by statement must be in the select statement (and all the fields in the select must be in the group by).

can you paste your code, so that we can help you better.

Hi,
Error is coming from the SELECT statement.
In that you have used some aggregation but you have not included all the field in the GROUP BY
You have to use all the fields in the group by.

regards