Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 12493 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
Is sql a backend language?
What are the different types of dbmss?
Does google use sql?
Why is partition used in sql?
Define join and name different types of joins?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is the difference between union and union all command?
What does rownum mean in sql?
Is stored procedure faster than query?
How does left join work in sql?
what is a composite key ? : Sql dba
What does the hierarchical profiler does?
What is right join in sql?
List the different type of joins?
What is nvl?
