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

how can we know the number of days between two given dates using mysql? : Sql dba

1048

how to get @@error and @@rowcount at the same time? : Sql dba

1028

What are triggers in sql?

1023

What is a trigger word?

1028

What is a common use of group by in sql?

1051

is it possible to pass an object or table to a procedure as an argument?

1135

Can we use the cursor's to create the collection in PL/SQL?

1030

What is a parameter query?

1090

What is before and after trigger?

963

What will you get by the cursor attribute sql%rowcount?

1042

Is coalesce faster than isnull?

967

how to create a test table in your mysql server? : Sql dba

1013

List the ways to get the count of records in a table?

900

Can a key be both primary and foreign?

999

How to create your own reports in sql developer?

1024