1. Queries for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query?

mahesh

• Aug 12th, 2013

Code
SELECT* FROM (SELECT RANK() 
over(ORDER BY price DESC) 
odrd,products.* FROM products) 
WHERE odrd =5;

priyank

• May 10th, 2012

Use Case in update statement

Answer Question  Select Best Answer