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
- 58865 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 do I start and stop sql server?
What is table level trigger?
What are 3 ways to get a count of the number of records in a table?
Explain the microsoft sql server delete command? : SQL Server Architecture
Can a function call a stored procedure in sql server?
How do I create an extended event in sql server?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is the fastest way to permanently delete a 1 million row table named customers?
What are the types of dml?
Explain what are commit and rollback in sql?
What is cross join in sql server joins?
How to change a login name in ms sql server?
What to check if a User database is locked?
Which trace flags are enabled in sql server?
What is optimization and its types?
