Find out the 3rd highest salary?
Answer Posted / tathagoto
select min(sal) from (select sal from (select sal from
salary order by sal desc) where rownum <
4);
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Compare sql & pl/sql
What is difference between my sql and sql?
How delete a row in sql?
What are different methods to trace the pl/sql code?
What sql does db2 use?
What is the difference between nested table and varray?
Does sqlite need a server?
What are all the different normalizations?
Is it possible to read/write files to-and-from PL/SQL?
What is meant by cursor in sql?
What is raw datatype in sql?
What is sql injection vulnerability?
What is lexical units in pl sql?
What are some emotional triggers?
What is a database event trigger?