How to find only %th Highest Sal
Answer Posted / abhishekjaiswal
SELECT A.FIRST_NAME,
A.SALARY
FROM EMPLOYEES A
WHERE 3 = ( SELECT COUNT(*) -- Replace 3 with any value of (N - 1)
FROM EMPLOYEES B
WHERE B.SALARY > A.SALARY)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does <> sql mean?
Is json a nosql?
What does cursor do in sql?
what are the different type of sql's statements ? : Sql dba
what is collation? : Sql dba
How do I order columns in sql?
What is mutating trigger?
What are the different datatypes available in PL/SQL?
How many scalar data types are supported in pl/sql?
Which join is default?
What is the difference between having clause and where clause?
what is heap table? : Sql dba
What is the difference between cross join and natural join?
what is the difference between nested subquery and correlated subquery?
What are pl sql procedures?