how to check the 3rd max salary from an employee table?
- 23 Answers
- 33784 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / danny
SELECT min( sal )
FROM emp
WHERE sal
IN (
SELECT DISTINCT sal
FROM emp
ORDER BY sal DESC
LIMIT 0 , 3
)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are sql objects?
What is scope and visibility in PL/SQL?
What are the different datatypes available in PL/SQL?
How do you write a complex sql query?
How delete all data from table in sql?
What are the parts of a basic sql query?
what are rollup and cube in t-sql? : Transact sql
What is the size of partition table?
Can we create index on primary key?
What is a file delimiter?
What is the usage of distinct keyword?
What does count (*) do in sql?
Why stored procedures are faster than query?
Does sql profiler affect performance?
what are set operators in sql? : Sql dba
