Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 12512 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 does varchar include?
Can you sum a count in sql?
What are types of indexes in sql?
What is primary key and foreign key with example?
What is the difference between inner join and outer join?
Mention what is the use of function "module procedure" in pl/sql?
I need a function for a train ticket reservation please answer it thanks in advance
When to use inner join and left join?
How do I run a sql query in pgadmin 4?
Is sql a oracle?
What is the use of non clustered index?
what is the use of double ampersand (&&) in sql queries?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is a constraint? Tell me about its various levels.
What does t sql mean?
