Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 12293 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
What do we need to check in database testing?
what is sql server agent? : Sql dba
Will truncate release space?
what is a trigger in mysql? Define different types of trigger. : Sql dba
How sql query is executed?
How do I audit the sql sent to the server?
What is the order of sql select?
Why are aggregate functions called so?
What view means?
How do I run a sql query?
What are the three pl sql block types?
Why truncate is faster than delete?
What is cursor explain with example?
How do temporal tables work?
What is the trigger in sql?
