EmpId Yr Sales 1 2005 12000.00 1 2006 18000.00 1 2007 25000.00 2 2005 15000.00 2 2006 6000.00 3 2006 20000.00 3 2007 24000.00
select EMPID,sum(Sales) as [totalsalesemployeewise],AVG(Sales)[avgsalaryemployee] from sales group by EmpId WITH ROLLUP
EMPID totalsalesemployeewise avgsalaryemployee 1 55000.00 18333.3333 2 21000.00 10500.00 3 44000.00 22000.00 NULL 120000.00 17142.8571
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)