how to find the second highest salary from emp table?
- 211 Answers
- 321332 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 / shankar panda
SELECT DISTINCT(E.SALARY) FROM EMPLOYEES E WHERE 2=(SELECT COUNT(DISTINCT D.SALARY) FROM EMPLOYEE D WHERE D.SALARY >= E.SALARY)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what does it mean to have quoted_identifier on? : Sql dba
What are database links used for?
What are the different dml commands in sql?
How do I turn a list into a table?
What are the benefits of pl/sql packages?
What is rollback?
What does where 1/2 mean in sql?
What is cross join example?
What is the difference between left join and right join?
What is the maximum number of columns in sql table?
what is an index? : Sql dba
Can a foreign key be null?
What is the purpose of a sql?
What does partition by mean in sql?
What is the sql case statement?
