Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367453 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
What is an oracle stored procedure?
What is the use of procedures?
What is record variable?
Why is partition used in sql?
What are the types of variables use in pl sql?
What is a left join?
how to escape special characters in sql statements? : Sql dba
Is left join same as inner join?
What is prepared statement in sql?
Why is a trigger used?
What is the difference among union, minus and intersect?
What is mutating table error?
Explain the methods used to protect source code of pl/sql.
How do I enable sql encryption?
What is offset and limit in sql?
