Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367462 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 / amarendra swain
select max(sal) from employee
where sal not in (select max(sal) from employee )
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is oracle and pl sql?
What is a temporal table?
What is record type in pl sql?
Is sqlite thread safe?
How to display Row Number with Records in Oracle SQL Plus?
What is the use of desc in sql?
What are some predefined exceptions in pl/sql?
Which function is used to return remainder in a division operator in sql?
How do you declare a user-defined exception?
What are sql*plus environment variables?
Whis is not false in primary key?
Why cross join is used?
What is attribute indicator in pl sql?
What is java sql drivermanager?
How do you explain an index?
