How to find only %th Highest Sal
- 6 Answers
- 10844 Views
- Infogain, Symphony, I also Faced
- E-Mail Answers
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
Explian rowid, rownum?
How do I find duplicates in sql?
What is substitution variable?
What are aggregate functions in sql?
What is scalar function in sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What are operators available in sql?
What is data definition language?
Which sql most popular?
What kind of join is join?
What is the use of triggers?
How many clustered indexes can you have?
What is right join sql?
Is sql injection illegal?
What is cold data?
