how to find the second highest salary from emp table?
- 211 Answers
- 321834 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 / chandu
select max(sal)from table name where sal<(select max sal
from table name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we use procedures in pl sql?
Does sql*plus have a pl/sql engine?
How does an execution block start and end in pl sql?
Is it possible to update views?
What are the popular database management systems in the it industry?
What is sqlcontext?
Can we call dml statement in function?
Why is theta join required?
What are all types of user defined functions?
explain access control lists. : Sql dba
What does := mean in pl sql?
How do I view a sql database?
what are all different types of collation sensitivity? : Sql dba
What are the different types of joins in sql?
What is union and union all keyword in sql?
