Interested to Buy Any Domain ? << Click Here >> for more details...
Query for second maximum salary in each in each department
- 15 Answers
- 37768 Views
- DST Global Solutions, TCS, I also Faced
- E-Mail Answers
Answer Posted / yaswanth
select salary from(select salary,rownum rk from(select salary from employees order by salary desc)) ehere rk=2;
| Is This Answer Correct ? | 2 Yes | 13 No |
Post New Answer View All Answers
What are the steps for performance tuning.
What does the sign mean in sql?
explain advantages of innodb over myisam. : Sql dba
how to calculate expressions with sql statements? : Sql dba
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What operating systems are supported by oracle sql developer?
What is a .db file?
Why indexing is needed?
Is sql similar to python?
Is left join inner or outer by default?
How to get each name only once from an employee table?
How many joins in sql?
Can you upgrade sql express to full sql?
What is dialect in sql?
Is it important to partition hard disk?
