Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368416 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 / sreekanth
SELECT MIN(SAL)
FROM(SELECT distinct SAL FROM EMP
ORDER BY SAL DESC)
WHERE ROWNUM <= :N
where N is the Nth highest salary u want
| Is This Answer Correct ? | 18 Yes | 22 No |
Post New Answer View All Answers
What is rename in sql?
How do I run pl sql in sql developer?
What is the difference between rename and alias?
How can a pl sql block be executed?
What are different types of keys?
What is the command used to fetch first 5 characters of the string?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Can we rollback after truncate?
What type of database is sql?
What is execution plan in sql?
What is data control language?
What is the primary use of normalization?
Can you join a table to itself?
How do you update a sql procedure?
Explain the uses of a database trigger?
