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 is pl sql block in dbms?
Can we update views in sql?
Explain what is a view?
What is the process of copying data from table a to table b?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is sql constant?
What is consistency?
What is the main reason behind using an index?
Can we call a function containing dml statements in a select query?
How do I run a script in sql developer?
what is the difference between delete and truncate statement in sql? : Sql dba
how to get a list of columns in an existing table? : Sql dba
what are all the different types of indexes? : Sql dba
what is a materialized view? : Sql dba
Which constraints we can use while creating database in sql?