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 to create a table index in mysql? : Sql dba

988

How do I view a sql database?

985

What type of join is sql join?

924

How to order siblings in oracle hierarchy queries?

983

How many types of triggers exist in pl/sql?

1011

What is scalar function in sql?

979

what is online transaction processing (oltp)? : Sql dba

938

What is a unique key and primary key and foreign key?

920

What are the operators used in select statements?

1002

how to use 'mysql' to run sql statements? : Sql dba

986

How many types of primary keys are there?

980

Explain what is dbms?

990

When to use inner join and left join?

906

What is primary key and foreign key?

917

what are the different index configurations a table can have? : Sql dba

939