Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367866 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 are the steps for performance tuning.
what is bdb (berkeleydb)? : Sql dba
Are views faster than queries?
Why are sql stored procedures used?
Can you have more than one trigger on a table?
What is lookup table in sql?
Why do we use procedures?
Which certification is best for sql?
Explian rowid, rownum?
What is union?
Explain isolation levels. : Transact sql
Is not equal in sql?
What is benefit of creating memory optimized table?
How to run pl sql program in mysql?
Which kind of parameters cannot have a default value in pl sql?
