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
- 55033 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
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 the stuff and how does it differ from the replace function?
What is openxml in sql server?
Explain the Ways to improve the performance of a sql azure database?
Define constraints and give an example of their use?
Explain in details security in SQL azure?
what is nonclustered index
What is an expression in ms sql server?
Can a table be moved to different filegroup?
Write a sql query to delete duplicate records from a table called table1
What are the operating modes in which database mirroring runs?
What is difference between rownum and row_number?
What is identity?
What are distinctive joins find as a part of sql?
how to determine the service pack currently installed on sql server? : Sql server database administration
Explain in brief how sql server enhances scalability of the database system?
