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
- 61237 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
what are the new features in SSRS?
How to loop through returning rows?
What is query cost in sql server?
How can you list all the table constraints in a database?
What is precedence constraint?
How to get a list of columns in a view using the "sp_help" stored procedure?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Can two different columns be merged into single column? Show practically?
Can the query output be sorted by multiple columns in ms sql server?
How to use values from other tables in update statements in ms sql server?
What is the difference between mysql and sql server?
Can you force a query to use a specific index?
How to list all dsn entries on your local machine using odbc_data_source()?
How to access the inserted record of an event?
What are the security related catalog views? : sql server security
