SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) / use column in Group By, but Hide column from the results set / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 14:52:11 GMT20RE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspx[quote][b]siggemannen (9/20/2012)[/b][hr]These kind of queries have real usage, for example if you want to preserve "duplicate rows" of Col1, Col2, which cannot be preserved if you only Group By Col1[/quote]Grouping By something which is not in the select is fine, I'm sure there are plenty of uses for that.But the original requirement - to include a column in select and in group by but then not to display it - is not so fine. I cannot think of a single use for that, other than as an example for a 'how to write superfluous SQL' book.Thu, 20 Sep 2012 07:28:46 GMTPhil ParkinRE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspx[quote][b]siggemannen (9/20/2012)[/b][hr]These kind of queries have real usage, for example if you want to preserve "duplicate rows" of Col1, Col2, which cannot be preserved if you only Group By Col1[/quote]Why would you want that?You would be missing information.Thu, 20 Sep 2012 07:25:57 GMTLuis CazaresRE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspxThese kind of queries have real usage, for example if you want to preserve "duplicate rows" of Col1, Col2, which cannot be preserved if you only Group By Col1Thu, 20 Sep 2012 06:26:40 GMTsiggemannenRE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspx[quote][b]Phil Parkin (9/19/2012)[/b][hr][quote][b]preetid2 (9/19/2012)[/b][hr]Thanks Phil! this worked perfect![/quote]I feel like I have entered a parallel universe.:alien:[/quote]I knew that! Your avatar makes everything right! What a solution! :hehe::hehe::hehe:Wed, 19 Sep 2012 14:12:12 GMTEugene ElutinRE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspx[quote][b]preetid2 (9/19/2012)[/b][hr]Thanks Phil! this worked perfect![/quote]I feel like I have entered a parallel universe.:alien:Wed, 19 Sep 2012 13:45:15 GMTPhil ParkinRE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspxThanks Phil! this worked perfect!Wed, 19 Sep 2012 13:38:59 GMTpreetid2RE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspxYou get too complicated. This should work.This will also give incomplete information on how the groups are made.[code="sql"]SELECT Col1, Count(*) AS Count_Rec FROM MyTable GROUP BY Col1, Col2[/code]Wed, 19 Sep 2012 12:51:36 GMTLuis CazaresRE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspx[quote][b]Phil Parkin (9/19/2012)[/b][hr][quote][b]Eugene Elutin (9/19/2012)[/b][hr]Yes it is possible, but what it will give you?[code="sql"]SELECT Col1, Count_RecFROM (SELECT Col1, Col2, Count(*) AS Count_Rec FROM MyTable GROUP BY Col1, Col2) aq[/code][/quote]Haha, what a fantastically useful query this would be :-D[/quote]Who knows, who knows... :hehe:Wed, 19 Sep 2012 11:45:51 GMTEugene ElutinRE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspx[quote][b]Eugene Elutin (9/19/2012)[/b][hr]Yes it is possible, but what it will give you?[code="sql"]SELECT Col1, Count_RecFROM (SELECT Col1, Col2, Count(*) AS Count_Rec FROM MyTable GROUP BY Col1, Col2) aq[/code][/quote]Haha, what a fantastically useful query this would be :-DWed, 19 Sep 2012 10:30:02 GMTPhil ParkinRE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspxCan you give an example of what you're thinking of?Wed, 19 Sep 2012 10:24:35 GMTlaurie-789651RE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspxYes it is possible, but what it will give you?[code="sql"]SELECT Col1, Count_RecFROM (SELECT Col1, Col2, Count(*) AS Count_Rec FROM MyTable GROUP BY Col1, Col2) aq[/code]Wed, 19 Sep 2012 10:20:12 GMTEugene ElutinRE: use column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspx[quote][b]preetid2 (9/19/2012)[/b][hr]Is this possible in sql server 2008?I want to use the column in the select, and group by. But want to hide the column from the results set?[/quote]No. If you select a column, it will appear.Wed, 19 Sep 2012 10:18:36 GMTPhil Parkinuse column in Group By, but Hide column from the results sethttp://www.sqlservercentral.com/Forums/Topic1361480-392-1.aspxIs this possible in sql server 2008?I want to use the column in the select, and group by. But want to hide the column from the results set?Wed, 19 Sep 2012 10:13:50 GMTpreetid2