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
- 58888 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 change data capture (cdc) in sql server 2008?
What are the two authentication modes in sql server?
Explain different types of lock modes in sql server 2000?
What are the different acid properties?
Can you leave a union at any time?
What is ms sql server service broker?
What do you think of this implementation? Can this be implemented better?
What are the different editions available in sql server 2000?
What is read uncmmited?
Explain why variables called the most powerful component of ssis?
Can we delete data from a view?
How each E-R model constructs can be mapped to the relational model?
How to create a view with data from multiple tables?
What is the log shipping?
Do you know sql server 2008 introduces automatic auditing?
