Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 60282 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / saikrishna reddy .k
To find second highest salary
select max(sal) from emp where sal not in (select max(sal)
from emp)
to find order
select top 5 8 from emp order by sal desc
| Is This Answer Correct ? | 30 Yes | 17 No |
Post New Answer View All Answers
What is difference between primary key and foreign key?
Can we write ddl in trigger?
How efficient you are in oracle and SQL server?
What is acid properties?
Explain the use of containers in ssis and also their types?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Can an automatic recovery be initiated by a user?
What is identity?
Explain how would you store your query in an SSRS report or a Database server?
How except clause is differs from not in clause?
Explain about sql server login?
What is the difference between lock, block and deadlock? : sql server database administration
Do you know what is blocking?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Define primary key?
