Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368242 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 / bibin__edappal
select salary from empTable where salary = (select
max(salary )from empTable where salary < (select max(salary
) from empTable))
OR
select salary from empTable where salary = (select
max(salary )from empTable where salary NOT IN (select
max(salary ) from empTable))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does oracle roll back the transaction on an error?
How is pl sql different from sql?
How does cross join work in sql?
Are views faster than queries?
Can we call dml statement in function?
Is left join faster than inner join?
What are the various levels of constraints?
What is string data type in sql?
How do I write a cron which will run a sql query and mail the results to agroup?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is rownum in sql?
What are the indexing methods?
What can you do with pl sql?
What is over () in sql?
How global cursor can be declare with dynamic trigger ?
