Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361205 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 / satish kumar
Select Top1 salary
from(select Distinct Top2 salary from employee order by salary DESC) a order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
How to select all records from the table?
Explain the savepoint statement.
What is an index in sql with example?
What is a record in pl/sql?
Is record in pl sql?
How delete a row in sql?
What is parallel hint?
What is column?
Does execute immediate commit?
How many sql statements are used?
How many types of index are there?
How many clustered indexes can be created on a table?
What is a behavioral trigger?
What found sql?
What does pragma mean?
