Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368260 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 / vijay shegokar
select * from employee where salary=(select max(salary) from
employee where salary not in (select max(salary) from
employee));
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between union and union all command?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
what are the differences among rownum, rank and dense_rank? : Sql dba
what is 'mysqlimport'? : Sql dba
What are sql indexes?
What is the difference between microsoft access and sql server?
What does the acronym acid stand for in database management?
What is rollback?
Can we use joins in subquery?
what is oltp (online transaction processing)? : Sql dba
What is multiple columns?
Explain the order of sql statement execution?
what happens if null values are involved in expressions? : Sql dba
Why is pl sql needed?
Why is sql important?
