Find out the 3rd highest salary?
Answer Posted / shaiju nair
select min(sal) from (Select sal
FROM emp where rownum<=3
Order by sal desc)
| Is This Answer Correct ? | 13 Yes | 25 No |
Post New Answer View All Answers
What is cte?
how to load data files into tables with 'mysqlimport'? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
Why do you partition data?
What is the use of sqldataadapter?
What is the max nvarchar size?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is the purpose of using pl/sql?
Are dml statements autocommit?
What is column?
What is a pdo connection?
Define join and name different types of joins?
What is sql catalog?
what are date and time intervals? : Sql dba
What is sql prepared statement?