Find out the 3rd highest salary?
Answer Posted / himanshu
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
How exception handling is done in advance pl/sql?
Can we use views in stored procedure?
define data blocks ? : Sql dba
Explain what is sql*plus?
Is crud a cuss word?
What is the difference between sum and count in sql?
In pl/sql, what is bulk binding, and when/how would it help performance?
how to load data files into tables with 'mysqlimport'? : Sql dba
What are the benefits of stored procedures?
Why does sql need a server?
What are the dml statements?
Are there any features that are decommissioned in 11g that are not present in 11g?
What are the types of join and explain each?
Mention what problem one might face while writing log information to a data-base table in pl/sql?