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
- 55152 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / rajeev
select salary-1 from users where salary in (select
max(salary) from users);
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is ms sql server triggers?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is a join in sql? What are the types of joins?
How many full-text indexes can a table have?
What is query optimization process?
Explain the Ways to improve the performance of a sql azure database?
What is openrowset sql server?
What's new in sql management studio for sql server? : sql server management studio
Why use stored procedures in sql server?
what are different types of backups available in sql server? : Sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is the purpose of the tempdb database?
How to check table values in sql server?
Which are the important points to note when multilanguage data is stored in a table?
How to round a numeric value to a specific precision?
