Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368420 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 / kiran
select max(sal) from emp where sal in(select sal from emp
where sal<>(select max(sal) from emp))
/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the key differences between SQL and PL SQL?
What is a left join?
How does pl sql work?
What is scalar function?
Can we write ddl statements in functions?
How to get help at the sql prompt?
Why are indexes and views important to an organization?
Can 2 queries be executed simultaneously in a distributed database system?
How you improve the performance of sql*loader? : aql loader
Why do we create views in sql?
Which data type is a composite type?
What is embedded sql in db2?
what are the types of subquery? : Sql dba
What are the different set operators available in sql?
What are aggregate and scalar functions?
