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
- 58924 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / bobby
select p.emp_id,p.name,p.salary from
( select emp_id,name,salary,dense_rank()over( order by
salary desc)rank
from empTable )p
where rank=2
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is RMS migrations?
What is default constraint in ms sql server?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
Can we write trigger for view?
What is SQL Azure?
What is deploy, process and build? : sql server analysis services, ssas
What is the bookmark lookup and rid lookup?
What is a deadlock and what is a live lock?
How to download microsoft sql server 2005 express edition?
What is the boxing and unboxing concept in .net?
How do I edit a stored procedure in sql server?
Tell me what are the essential components of sql server service broker?
Why are you getting errors when creating a new odbc dsn?
Can you name some of the dml commands in sql?
Explain partitioned view?
