| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
Question: how many columns can be in the group by clause
|
| August 08, 2008 13:58:11 |
#4 |
| rajaraddi |
Member Since: August 2008 Total Comments: 1 |
RE: how many columns can be in the group by clause
|
For Aggregation:
No. of cols in group by clause = No. of cols in SELECT clause - No. of cols to be aggregated.
For eliminating the duplicates
No. of cols in group by clause = No. of cols in SELECT clause.
In general there might be n number of cols that can be used in the group by clause, which depends on
your number of cols present in SELECT clause
Thanks,
Raju |
| |
Back To Question | |
