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 Lock table in SQL?
How do you make a trace?
Tell me what is the stuff and how does it differ from the replace function?
What is the use of set nocount on/off statement?
What is difference between inner join and full join?
Explain about extended stored procedure?
How many types of keys are there?
Can you please differentiate between a primary key and a unique key?
How to run sql server 2005 books online on your local system?
What are the differences between lost updates and uncommitted dependencies?
How to create new table with "create table" statements?
How is table type constraint applied to a table?
Explain indexes disadvantages?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is transaction server distributed transaction?