Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 60242 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / balaji
TO FIND THE N-1th HIGHEST SALARY IN EMP TABLE
Select Min(salary) from emptable where salary not in(Select
Min(salary) from emptable)
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to store and query spatial data?
What is transaction server auto commit?
Can another user execute your local temporary stored procedures?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Explain what is lock escalation?
Do you know hot add cpu in sql server 2008?
Can we create clustered index on composite key?
What is the difference between system objects and user objects?
What does set rowcount do?
What is difference between clustered index and non clustered index?
How to list all login names on the ms sql server?
What is implicit mode in sql server?
Can I run multiple instances of sql server 2000 at the same time on one computer?
How can change procedure in sql server?
What are cascading parameters in ssrs reports?
