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)
