Shortcut in Group by clause...

Database
Enthusiast

Shortcut in Group by clause...

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.

1 REPLY
Supporter

Re: Shortcut in Group by clause...

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 ;-)