SELECT TOP 1 salary FROM ( select TOP 5 salary FROM employee ORDER B

How to get employee name from employee table which is the
fiveth highest salary of the table

Question Posted / praveen

Answer Posted / praveen

SELECT TOP 1 salary
FROM
(
select TOP 5 salary
FROM
employee
ORDER BY
salary DESC
) A
ORDER BY
salary

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does inner join return duplicate rows?

949

What is compilation error in pl sql?

947

What is the difference between inner join and outer join?

954

Can we join tables without foreign key?

930

What is the need of a partition key?

960

What are some emotional triggers?

952

What is difference between inner join and cross join?

935

What is the sql*loader? : aql loader

1030

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

928

What is acid property in a database?

1004

What are the usages of sql?

1032

How to write pl sql program in mysql command prompt?

1047

What is program debugging?

1184

Why use truncate instead of delete?

978

Is left join inner or outer?

990