Find out the 3rd highest salary?

Answer Posted / anjali

select min(column_name) from table where column in(select
top n
column_name from table order by column_name desc)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we store rows in PL/SQL using array?

670


How does sql profiler work?

574


Can we use commit inside a trigger?

533


explain the advantages and disadvantages of stored procedure? : Sql dba

536


What is sql lookup?

516






What is a parameter query?

628


How can we find duplicate records in a table?

517


How do I find sql profiler?

524


What is a table in a database?

589


Is sqlite good enough for production?

542


What is use of package in pl sql?

536


Why we use triggers in mysql?

564


What is %type in pl sql?

545


How to get list of all tables from a database?

633


What packages are available to pl/sql developers?

605