Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367824 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 / hemanth kumar
select salary from employees where rowid=(select rowid from
employees where rownum<=2
minus
select rowid from employees where rownum<2)
order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you know that statistics should be updated?
Why are aggregate functions called so?
Is sql open source?
How do rank () and dense_rank () differ?
What is join view in sql?
What are character functions in sql?
What is before and after trigger?
what is self join and what is the requirement of self join? : Sql dba
What is dense_rank in sql?
What is the best partition size for windows 10?
What is dbo in sql?
What is the difference between function and procedure in pl/sql?
What is memory optimized?
how to use myisamchk to check or repair myisam tables? : Sql dba
Can cursors be part of a trigger body?
