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 many ways to get the current time? : Sql dba

709


What is an example of translating a date into julian format?

775


What is a native sql query?

701


What is interval partition?

724


How to install oracle sql developer?

771






Is foreign key mandatory?

715


What is a Mapplet?

824


what are null values? : Sql dba

708


Can we insert data in view?

691


What are the sql versions?

672


How can I see all tables in sql?

727


how to delete an existing column in a table? : Sql dba

716


Is mariadb nosql?

765


What are analytical functions in sql?

729


How do I view a sql trace file?

756