Can we use subquery in group by ?
learner1Mar 24 2010 — edited Mar 24 2010Hi,
I am preparing for 11ig SQL certification , and while studying came across a doubt.
We can have a subquery for
SELECT
FROM
WHERE
HAVING
and we cannot have a subquery for ORDER BY clasuse
but my question is how about GROUP BY clause, can we use subquery in GROUP BY clause ?
The book which i am referring says we cannot have a subquery for GROUP BY, but surprisngly in practice questions at the end of chapter , it says opposite, which really confused me ..
Regards
Learner