SELECT first_name, salary FROM employees E1 WHERE (5) = (SELECT COUNT(DIST

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

Question Posted / ajeet

Answer Posted / ajeet

SELECT first_name, salary FROM employees E1
WHERE (5) = (SELECT COUNT(DISTINCT(E2.salary))
FROM employees E2
WHERE E1.salary < E2.salary)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1007

What are triggers in sql?

974

what is isam? : Sql dba

953

Is oracle sql free?

928

How to raise user-defined exception with custom sqlerrm ?

1063

Is left join and outer join same?

1005

Explain ddl statements in pl/sql?

961

How to make a copy values from one column to another in sql?

985

What is the use of & in pl sql?

988

What is a sql profiler?

963

What is coalesce sql?

943

How do I truncate a word?

1002

What is data control language (dcl)?

1047

How does an execution block start and end in pl sql?

901

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

1016