Interested to Buy Any Domain ? << Click Here >> for more details...
how to calcuate the second highest salary of he employee
- 13 Answers
- 18062 Views
- Synechron, I also Faced
- E-Mail Answers
Answer Posted / eshwer
Try this
select * from (SELECT empno,sal, DENSE_RANK() OVER (ORDER BY sal desc) AS SalRnk
FROM scott.emp) where salrnk=2;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the benefits of triggers?
Why we use joins in sql?
How to add new employee details in an employee_details table with the following details
What is primary key and foreign key?
What is pl sql in oracle?
How do I install microsoft sql?
Which nosql database is best?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Which is better join or subquery?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What are transaction and its controls?
What are different types of triggers?
What are the types of subqueries?
What is difference between table and view?
Can we rollback delete command?
