Saturday 23 March 2013

Group by in Sql Server

Written By:- Isha Malhotra
Our Website:-Tech Altum
Group by
Sometimes you need to show data in some groups with some aggregate function. In this situation you can use group by statement.

For example:-

Check the data of following table. Suppose you want to show the sum of all no of prod according to year. In that case you use group by statement.


No comments:

Post a Comment