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 is data manipulation language?

1187

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1071

Does execute immediate commit?

1216

Why do we create views in sql?

1149

Are views faster than queries?

987

how to concatenate two character strings? : Sql dba

1096

how can we destroy the session, how can we unset the variable of a session? : Sql dba

997

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1699

What is implicit cursor in pl sql?

1090

Can a view be mutating? If yes, then how?

1026

What is the difference between an inner and outer join?

1011

What is the maximum rows in csv?

920

What is over () in sql?

953

what are all the different types of indexes? : Sql dba

1046

Explain how can you save or place your msg in a table?

1026