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
- 35 Answers
- 55277 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
Explain Reporting Life Cycle?
What is sql server agent and what are the two modes of authentication in sql server?
What happens if the update subquery returns no rows in ms sql server?
Explain the use of containers in ssis?
What is the Difference Between Primary and Foreign Key?
What is partition index in sql server?
What are the different sql server versions?
What is the distinction amongst delete and truncate?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Which rendering formats are affected by the pagesize properties?
What is index, cluster index and nonclustered index?
What is @@error in sql?
How to end a stored procedure properly in ms sql server?
your distribution database is full what will u do
If user is owning any SQL Objects, can we drop that user
