how to find the second highest salary from emp table?
- 211 Answers
- 322087 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 / prashanth
select max(sal) from employee where sal<(select max(sal)
from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is difference between joins and union?
What is the difference between joins?
How do you sort in sql?
What is restrict in sql?
How can we debug in PL/SQL?
What does where 1/2 mean in sql?
How do I clear the screen in sql plus?
What is the difference between drop and truncate commands?
How would you convert date into julian date format?
How to run pl/sql statements in sql*plus?
What mean sql?
Is left join inner or outer?
What does := mean in pl sql?
How do I view a table in sql?
Can we create view in stored procedure?
