how to find the second highest salary from emp table?
- 211 Answers
- 321397 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 / abhishek kundu
SELECT MAX(SALARY) FROM EMP
WHERE SALARY<(SELECT MAX(SALARY) FROM EXP);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
When do we use triggers?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Why do we go for stored procedures?
what is 'trigger' in sql? : Sql dba
Do stored procedures prevent sql injection?
explain access control lists. : Sql dba
What is pl sql in oracle?
Why commit is not used in triggers?
what is the difference between truncate and drop statements? : Sql dba
What is a recursive join sql?
What are all ddl commands?
Is sql developer case sensitive?
Can procedure in package be overloaded?
What are sql ddl commands?
How does pl sql work?
