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
- 59282 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 read data in a table with "select" statements?
What are views used for?
how we use window authentication connection with sql server.?
What are the tables in sql?
What is enhanced database mirroring in sql server 2008?
What is the difference between char, varchar and nvarchar?
What is the purpose of forms?
What is a trigger what are the advantages of trigger?
How to retrieve field values using mssql_result()?
How to replace null values in expressions using isnull()?
Explain table valued parameters in sql server? Why tvp used?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is the native system stored procedure to execute a command against all databases?
what is a live lock? : Sql server database administration
What is RMS migrations?
