Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361079 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
How do I count rows in sql?
When is the update_statistics command used?
How will you distinguish a global variable with a local variable in pl/sql?
What are different types of sql?
Why procedure is used in sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
How is data stored on a disk?
What is a table partition?
Why do we use procedures in pl sql?
What is output spooling in sql*plus?
What are the different types of database management systems?
What is the primary use of normalization?
What is anonymous block in sql?
How sql query is executed?
How do you concatenate in sql?
