Interested to Buy Any Domain ? << Click Here >> for more details...
how to calcuate the second highest salary of he employee
- 13 Answers
- 19032 Views
- Synechron, I also Faced
- E-Mail Answers
Answer Posted / udhayakumar
select salary from (select salary from emp order by salary
desc) where rownum=2;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what are the features and advantages of object-oriented programming? : Sql dba
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What plvcmt and plvrb does in pl/sql?
What is sql performance tuning?
What is rownum in sql?
What does 0 mean in sql?
How to know the last executed procedure?
What is raid? How does it help storage of databases?
what are all different types of collation sensitivity? : Sql dba
What is the use of triggers?
Can we create foreign key without primary key?
When is the explicit cursor used ?
How do I save a stored procedure?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is the mutating table and constraining table?
