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

What is clustered and nonclustered index in sql?

987

How do I create a memory optimized filegroup?

1012

Is sql developer case sensitive?

1048

Is sql microsoft?

1108

How can you tell the difference between an index and a view?

978

Which sql statement is used to delete data from a database?

1010

Are there any features that are decommissioned in 11g that are not present in 11g?

2198

describe mysql connection using mysql binary. : Sql dba

1124

What is identity column in sql server?

1103

How many commands are in sql?

1121

How can we implement rollback or commit statement in a trigger?

1085

How to write pl sql program in mysql command prompt?

1165

What is the main reason behind using an index?

1060

What is a table in a database?

1096

What is plpgsql language?

1142