mysql> select max(sal) from emp where sal not in (select max(sal) from

How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database

plz mail the answer @ mak2786@gmail.com

Question Posted / veerdhawal

35 Answers
60277 Views
Oracle, Scend, TechInfini, I also Faced
E-Mail Answers

Answer Posted / veerdhawal

mysql> select max(sal) from emp where sal not in (select
max(sal) from emp);
+----------+
| max(sal) |
+----------+
| 30000 |
+----------+
1 row in set (0.01 sec)

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the difference between primary key and unique key? : sql server database administration

945

What is a deadlock and what is a live lock?

1003

When do you think a developer should use sql server-based cursors?

1052

What is full outer join in sql server joins?

1074

Will sql server 2005 allow you to reduce the size of a column?

996

What is scalar user-defined function?

1110

What is page in sql server?

953

Write a code to select distinct records without using the DISTINCT keyword.

1120

What is federation member?

116

When would you use sql joins?

965

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4389

how would you improve etl (extract, transform, load) throughput?

1033

what are constraints? Explain different types of constraints? : Sql server database administration

994

What is difference between count (*) and count 1?

933

is there a column to which a default can't be bound? : Sql server database administration

1019