Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368608 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 / manoj
select * from emp
where
sal=(select MAX(sal) from emp
where
sal<(select MAX(sal)from emp))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the importance of sqlcode and sqlerrm?
Can a commit statement be executed as part of a trigger?
What is basic structure of pl sql?
How many sql databases can you have on one server?
What is the maximum number of columns in sql table?
What is integrity in sql?
What is scope and visibility in PL/SQL?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Is it possible to pass parameters to triggers?
Define overloaded procedure?
How do you concatenate in sql?
How many times can we commit in a loop?
Can there be 2 primary keys in a table?
what is unique key constraint? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
