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

Can dml statements be used in pl/sql?

1074

What is varchar sql?

1132

What is sql select statement?

1028

Can we use commit inside a trigger?

1086

how to extract a unit value from a date and time? : Sql dba

990

What is numeric function sql?

1055

What is Difference Between Unique and Primary Key Constraints?

1104

What is self-join and what is the requirement of self-join?

1149

Differentiate between syntax and runtime errors.

1181

Is progress software supports to ( pl/sql )?

1034

What does bitemporal mean?

1063

Can you join views in sql?

951

What are the different types of constraints?

1176

What is the best sql course?

977

What is the main difference between sql and pl/sql?

1094