How to difference between group by and group by all in SQL

Question

How to difference between group by and group by all in SQL? Thanks you very much

Vilas Gite · Answer

hI tOANHOI Please check this... http://www.w3schools.com/sql/sql_groupby.asp ------------------------------------------------------------------------- If this reply solve your post…then  MARK AS ANSWER !

Pradeep Chandraker · Answer

The Group By All returns all groups even if some groups have no rows. But Group By returns only those groups which has rows. You may go through below link for more details: http://msdn.microsoft.com/en-us/library/ms175028(v=sql.90).aspx