Find out the 3rd highest salary?

Answer Posted / shibin k abraham

select * from emp where sal=(select a.sal from emp awhere 3=(select distinct(count(b.sal)) from emp b where a.sal<=b.sal))

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I start sql from command line?

612


How to fetch alternate records from a table?

778


Is nosql relational?

622


What is union?

731


how can we destroy the cookie? : Sql dba

643






Are subqueries better than joins?

620


explain advantages of myisam over innodb? : Sql dba

706


What is a database? Explain

683


Is a secondary key the same as a foreign key?

583


what are the join types in tsql? : Transact sql

663


what is the use of set statement in tsql? : Transact sql

622


Is pl sql useful?

633


how can we find the number of rows in a table using mysql? : Sql dba

673


Which nosql database is best?

586


how would you get the current date in mysql? : Sql dba

628