Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 12246 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
how to start mysql server? : Sql dba
what is the difference between join and union? : Sql dba
How can you fetch common records from two tables?
how to concatenate two character strings? : Sql dba
Explain the methods used to protect source code of pl/sql.
Explain the types of joins in sql?
What is sqlexception in java?
What is join view in sql?
Is ms sql is free?
What are different joins used in sql?
What is latest version of sql?
Describe sql comments?
what is acid property in database? : Sql dba
What are procedures used for?
What is the usage of the distinct keyword?
