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
Answer Posted / neon
select salary from emp
where salary = (select max(salary) from emp
where salary <>(select max(salary) from emp)
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Define indexes?
What is a recursive stored procedure in sql server?
How to enable tcp/ip protocol on a sql server?
How many types of built in functions are there in sql server 2012?
Explain trigger and its types?
What is the report builder?
Explain what you mean by 3 tier architecture.
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Difference between Sql server reporting services and Crystal reports?
What is built-in function?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Can we perform backup restore operation on tempdb? : sql server database administration
Why use triggers?
How to return the top 5 rows from a select query in ms sql server?
How to rebuild master databse?