how to find the second highest salary from emp table?
- 211 Answers
- 321099 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 / pradeep
select sal from emp
where rownum=2
order by sal desc
| Is This Answer Correct ? | 10 Yes | 50 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What does (*) mean in sql?
How is indexing done in search engines?
describe transaction-safe table types in mysql : sql dba
How many disk partitions should I have?
what are sequences
How do I restart sql?
What are the benefits of pl sql?
What is cursor status?
Which command is used to delete a trigger?
Which certification is best for sql?
How to run pl/sql statements in sql*plus?
What is clause in sql?
How do I find sql profiler?
Is sql procedural language?
What is rowtype?
