Regarding Group by clause

skumars.tripathi · New User Joined: 27 May 2010 Posts: 12 Location: Kolkata

Is it necessary that all the columns used in agregate function should be present in the Group by clause?

For ex. If i have used some column name in the SUM function, then that should also be there in Group by clause.

Thanks in advance
Sanjay

GuyC · Posted: Thu Jul 15, 2010 4:53 pm

No , exactly the opposite : all selected columns NOT in aggregate functions must be in the group by clause.
well, kind of. it gets more complicated when using functions like substr() , year(),...