how to find the second highest salary from emp table?
- 211 Answers
- 322081 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 / kishor dange
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
What is compilation error in pl sql?
What do you understand by pl/sql cursors?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
How many triggers can be applied on a table?
Do ddl statements need commit?
What is the difference between unique and primary key constraints?
what are date and time intervals? : Sql dba
How to read xml file in oracle pl sql?
How does postgresql compare to mysql?
Why does sql need a server?
What is denormalization in a database?
Which data dictionary views have the information on the triggers that are available in the database?
What does joining a thread mean?
how to convert numeric values to character strings? : Sql dba
What is a left join?
