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
- 51178 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / saikrishna reddy .k
To find second highest salary
select max(sal) from emp where sal not in (select max(sal)
from emp)
to find order
select top 5 8 from emp order by sal desc
| Is This Answer Correct ? | 30 Yes | 17 No |
Post New Answer View All Answers
Which joins are sql server default?
What are the different types of locks in the database?
Where are sql server user names and passwords stored in sql server?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Do you know what is sql service broker?
What are system databases in ms sql server?
What is replication and database mirroring?
How can sql injection be stopped? : sql server security
What is clustered index
How many replicas are maintained for each sql azure db?
What is the difference between coalesce() & isnull()?
What is the current pricing model of SQL Azure?
What is difference between index seek vs. Index scan?
How to create a local temporary stored procedure?
what is database replication? : Sql server database administration
