Saturday, 13 April 2013

How to find the 5 th MAX Salary in sql server 2008



create table Employee2000 (eno int,ename varchar(30),Sal int );

insert into Employee2000 values (1,'ANIL',25000)
insert into Employee2000 values (2,'SUNIL',24000)
insert into Employee2000 values (3,'Rajesh',23000)
insert into Employee2000 values (4,'Kamesh',22000)
insert into Employee2000 values (5,'RUPESH',21000)










select sal from Employee2000 e1 where 4=(select COUNT(*) from Employee2000 f1 where e1.Sal<f1.Sal)



No comments:

Post a Comment

SQLDBA- SQL Server Wait Events

  To solve slowness of SQL Server database, you should find which wait events exists in the database. You can find wait events of database w...