how to find the second highest salary from emp table?
- 211 Answers
- 322604 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 / raghu munukutla
SQL> select max(sal) from emp where rownum<=(select
count(sal)-1 from emp)
order by sal desc;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are operators available in sql?
Does user triggers have entry for trigger with compilation errors?
How many sql commands are there?
does sql support programming? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Is like operator in sql case sensitive?
What is a join?
how can you see all indexes defined for a table? : Sql dba
What is memory optimized table?
What is a memo field?
How can a pl sql block be executed?
What are pl sql data types?
Determine if oracle date is on a weekend?
What is sql injection owasp?
What is cursor in pl sql?
