how to calcuate the second highest salary of he employee
- 13 Answers
- 15070 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 is sql exception?
Why sql query is slow?
How to process query result in pl/sql?
How do I view a view in sql?
Can a key be both primary and foreign?
What is a function in oracle pl sql?
how is exception handling handled in mysql? : Sql dba
Is sql workbench free?
How do I sort a table in sql?
What is compute?
What is the purpose of my sql?
List the various privileges that a user can grant to another user?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is the use of function "module procedure" in pl/sql?
Why partition by is used in sql?
