Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 369157 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 / winnie
select max(sal) from emp
where sal not in (select max(sal) from emp )
| Is This Answer Correct ? | 1090 Yes | 131 No |
Post New Answer View All Answers
What are sql constraints?
What is the use of <> sql?
How do you bind variables in pl sql?
What is 19 null in sql?
Explain what is a view?
What is the difference between subquery and correlated query?
How does sql store data?
What plvcmt and plvrb does in pl/sql?
What are the different types of functions in sql?
How to handle bulk data?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Which data dictionary views have the information on the triggers that are available in the database?
How do you use a while loop in pl sql?
How many joins in sql?
How to use distinct and count in sql query? Explain
