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
What is mean by dml?
Please differentiate between a local and a global temporary table?
How to create a trigger for insert only?
Differentiate between a primary key and a unique key.
where the connection string store in the database
What is set nocount on?
When to use Inner join & when to use subquery?
What is user-defined inline table-valued function?
What is default constraint in ms sql server?
How to Insert multiple rows with a single insert statement?
Explain the categories of stored procedure?
How connect excel to sql server?
What is the command used to recompile the stored procedure at run time?
How do I perform an unattended install of sql server 2000?
Do you know how to send email from database?