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
How do I start sql from command line?
How to fetch alternate records from a table?
Is nosql relational?
What is union?
how can we destroy the cookie? : Sql dba
Are subqueries better than joins?
explain advantages of myisam over innodb? : Sql dba
What is a database? Explain
Is a secondary key the same as a foreign key?
what are the join types in tsql? : Transact sql
what is the use of set statement in tsql? : Transact sql
Is pl sql useful?
how can we find the number of rows in a table using mysql? : Sql dba
Which nosql database is best?
how would you get the current date in mysql? : Sql dba