how to find the second highest salary from emp table?
- 211 Answers
- 320946 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / bharat puri
select top 2 (salary) from emp
order by salary desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What's the difference between a primary key and a clustered index?
What is union, minus and interact commands?
How does stored procedure reduce network traffic?
How do you update a sql procedure?
What is a file delimiter?
What are views in sql?
How to combine two stored procedures in sql?
What is memory optimized table?
What do we need to check in database testing?
What is group by in sql?
what are all different types of collation sensitivity? : Sql dba
What is auto increment in sql?
What is the trigger in sql?
What is sqlerrm?
What is trigger with example?
