Interested to Buy Any Domain ? << Click Here >> for more details...
Query for second maximum salary in each in each department
- 15 Answers
- 38316 Views
- DST Global Solutions, TCS, I also Faced
- E-Mail Answers
Answer Posted / nancy singhal
select max(salary) from emp where salary in(select salary
from emp where salary not in(select max(salary) from emp));
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Is there any restriction on the use of union in embedded sql?
What is sap sql anywhere?
How do I view a procedure in sql?
Show code of a cursor for loop.
What are sql built in functions?
Which are sql * plus commands?
What is scope and visibility in PL/SQL?
What is rownum?
Who developed sql?
What is meant by temporal data?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is normalization in a database?
What is query execution plan in sql?
What is a left join?
What does varchar include?
