SQL Server - group by clause

You could use aggregate functions in combination with group by clause..

Something like this..

SELECT region, SUM(Salary)
FROM Employee
WHERE ID BETWEEN 1 AND 10
GROUP BY Region

Hi Shekhar,

You need to give all the columns in group by unless the particular column is aggregated. your example

SELECT v.Voucher_NO as VoucherNo, v.Voucher_Id as VID, date_format(Voucher_Date,'%d/%c/%Y') as vdate,

v.Voucher_Type, v.Voucher_PayeeName as name, v.Voucher_ReceivedBy as receiver, e1.Emp_FirstName as a_FName,

e1.Emp_MiddleName as a_MName, e1.Emp_LastName as a_LName, e2.Emp_FirstName as c_FName, e2.Emp_MiddleName as c_MName,

e2.Emp_LastName as c_LName, v.Voucher_Amount as totoal FROM vouchermaster v

inner join employee e1 on e1.Emp_Id=v.Voucher_CertifiedBy

inner join employee e2 on e2.Emp_Id=v.Voucher_ApprovedBy

where Voucher_Date between 'date1' and 'date2' and Voucher_Status='0'

group by v.Voucher_NO , v.Voucher_Id , date_format(Voucher_Date,'%d/%c/%Y') ,

v.Voucher_Type, v.Voucher_PayeeName , v.Voucher_ReceivedBy , e1.Emp_FirstName ,

e1.Emp_MiddleName , e1.Emp_LastName , e2.Emp_FirstName , e2.Emp_MiddleName ,

e2.Emp_LastName , v.Voucher_Amount

order by Voucher_Type, Voucher_Date desc

Hope it helps

Manish