CREATE TABLE #emp
(
Dept varchar(100),
Emp varchar(100),
Sal numeric(18,2)
)
INSERT INTO #Emp values('Comp','A',6000)
INSERT INTO #Emp values('Comp','B',7000)
INSERT INTO #Emp values('Comp','C',10000)
INSERT INTO #Emp values('Comp','D',9000)
INSERT INTO #Emp values('Elec','P',2000)
INSERT INTO #Emp values('Elec','Q',10000)
INSERT INTO #Emp values('Elec','R',11000)
INSERT INTO #Emp values('Eng','AA',15000)
INSERT INTO #Emp values('Eng','BB',2000)
/* I want the output (Department wise top 2 highest salary, where department might be dynamic text)
Dept Emp Sal
----------------------------
Comp C 10000
Comp D 9000
Elec R 11000
Elec Q 10000
Eng AA 15000
Eng BB 2000
*/