Home > DeveloperSection > Forums > Group By Clause
Anurag Chaurasia
Anurag Chaurasia

Total Post:16

Points:112
Posted on    May-24-2011 10:23 PM

 MSSQL Server MSSQL Server 
Ratings:


 1 Reply(s)
 1294  View(s)
Rate this:
How we can fetch full table data by using group by clause without using any aggregate functions ? Please help me its urgent....


Awadhendra Tiwari

Total Post:126

Points:882
Posted on    May-25-2011 1:45 AM

Hi.. Anurag

Try following query this might be helpful for you.

select * from Student group by sid,sname,sage,scity.

Simply you will right all name of column of table on right side of group by clause and you got solution.


Don't want to miss updates? Please click the below button!

Follow MindStick