how to find the second highest salary from emp table?
- 211 Answers
- 321769 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 / subrat
SELECT MAX(Sal) FROM EMP WHERE Sal < (SELECT MAX(Sal) FROM EMP)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a database event trigger?
does sql support programming? : Sql dba
Explain the components of sql?
State few characteristics of pl/sql?
How to find 3rd highest salary of an employee from the employee table in sql?
Why do we use joins in sql?
What does partition by mean in sql?
what is cross join? : Sql dba
What are the types of variables use in pl sql?
How to place comments in pl/sql?
How to install oracle sql developer?
What has stored procedures in sql and how we can use it?
what is a trigger in mysql? : Sql dba
What is the meaning of disabling a trigger?
How is indexing done in search engines?
