how to check the 3rd max salary from an employee table?
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 operators deal with null?
What is trigger explain it?
Can two tables have same primary key?
how do you know if your mysql server is alive? : Sql dba
What is offset and limit in sql?
What are tables in sql?
Does truncate require commit?
Is sql injection illegal?
What is package in pl sql with an examples?
describe mysql connection using mysql binary. : Sql dba
Why do we need view in sql?
What is serial sql?
What is a full join?
What is the difference between partition and index?
What are the limitations of sql express?