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
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is normalization in sql?
What is union?
What are the indexing methods?
What are the different types of tables in sql?
Can we call dml statement in function?
What is the starting oracle error number?
What are synonyms in sql?
What is a sql profiler?
How long will it take to learn pl sql?
How to sort the rows in sql.
what is not null constraint? : Sql dba
Is sql a microsoft product?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba