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

Total Post:16

Posted on    May-24-2011 10:23 PM

 MSSQL Server MSSQL Server 

 1 Reply(s)
 1267  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

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