create table employee1(emp_id int, first_name varchar(20),last_name varchar(20),designation varchar(20), salary float, doj date)

insert into employee1 values (1001,'kumar', 'babu', 'jr_analyst',10000,'01-jan-2014')

insert into employee1 values (1002,'sai', 'babu', 'jr_analyst',10000,'05-jan-2014')

insert into employee1 values (1003,'dinesh', 'babu', 'jr_analyst',10000,'10-jan-2014')

insert into employee1 values (1004,'naresh', 'babu', 'sr_analyst',16000,'01-feb-2010')

insert into employee1 values (1005,'ravi', 'kumar', 'sr_analyst',16000,'01-mar-2010')

insert into employee1 values (1006,'seshu', 'vardan', 'sr_analyst',16000,'01-aug-2012')

insert into employee1 values (1007,'sai', 'vardan', 'developer',15000,'01-july-2014')

insert into employee1 values (1008,'sasi', 'kanth', 'developer',15000,'01-july-2014')

alter table employee1 add constraint empid primary key(emp_id)

insert into employee1 values (1009,'prasanth', 'reddy', 'developer',15000,'01-aug-2017')

insert into employee1 values (1010,'rakesh', 'reddy', 'developer',15000,'01-aug-2016')

select * from employee1

select salary from(select salary from (select salary from employee1 order by salary desc) 
where rownum<=9 order by salary )where rownum<=1;