Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368199 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 / rajesh chauhan
sql>select max(salary)from(select salary from employee where
salary not in(select max(salary)from employee))
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Cite the differences between execution of triggers and stored procedures?
Which data dictionary views have the information on the triggers that are available in the database?
What is a join?
What is the difference between left outer join and left join?
What is insert command in sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Which is faster truncate or drop?
What do you understand by pl/sql records?
Is left join same as inner join?
How to convert comma separated string to array in pl/sql?
What is sql character function?
Why do we use partitions in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Is big data nosql?
Why use subqueries instead of joins?
