how to find the second highest salary from emp table?
- 211 Answers
- 321515 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 / abir dutta
select min(empsal)
from (select * from sal order by empsal desc)
where rownum <=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between having and a where in sql?
What is nvl?
What are the types of triggers in sql?
i have some prob lem to tell me about my self in interview first round ...
What is difference between sql and oracle?
What is the difference between the conventional and direct path loads? : aql loader
What is difference between sql function and stored procedure?
What is a data definition language?
How to convert comma separated string to array in pl/sql?
How you improve the performance of sql*loader? : aql loader
How do I write a cron which will run a sql query and mail the results to agroup?
What is field delimiter?
What is mdb stand for?
How many types of sql are there?
What are pl/sql cursors?
