Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368660 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 / amarendra swain
select max(sal) from employee
where sal not in (select max(sal) from employee )
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between implicit and explicit cursors?
Which software is used for pl sql programming?
Advantages and disadvantages of stored procedure?
What does count (*) mean in sql?
What are the advantages of normalization?
What are the uses of sysdate and user keywords?
How can you create an empty table from an existing table?
Is inner join same as self join?
What is scope of pl sql developer in future?
Which are the different character-manipulation functions in sql?
how can we submit a form without a submit button? : Sql dba
How do I edit a stored procedure?
What are local and global Indexes and where they are useful.
What packages are available to pl/sql developers?
What is partition by in sql?
