Say i am selecting 30 columns and i want to give Group by clause. In my case i have to give group by 1,2,3...30. Is there any shortcut say Group by *. Is there any other way other than using distinct.
I am not aware of this kind of short cut - and would event not advise to use it in production code if it would exists ;-)