Find out the 3rd highest salary?
Answer Posted / suba
(Instead of 3 we can find N highest value)
select min(sal) from emp e where 3>(select count(sal) from
emp where sal>e.sal);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql trigger example?
How is debugging done?
What is microsoft t sql?
Can you do multiple joins in sql?
What is pl sql architecture?
what is “go” in t-sql? : Transact sql
What are keys in sql?
What is varchar example?
What is a unique key and primary key and foreign key?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
How do I save a stored procedure?
What are pl sql data types?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is a sql instance vs database?
How to use transactions efficiently : transact sql