Answer / kedar

select max(salary) from employees where salary < (select
max(salary) from employees);


the max salary is 24000
& second max is 17000
chwck out

Answer / shahnaz

To find the 2nd highest salary from emp table:

select max(sal) from emp where sal not in (select max(sal)
from emp )

Answer / manikandan. s

This is the nth max

SELECT salary
FROM (SELECT ROWNUM sl, salary
FROM (SELECT salary
FROM employees
GROUP BY salary
ORDER BY salary))
WHERE sl = n

Answer / mahesh

SELECT *
FROM (SELECT ROWNUM sl, salary
FROM (SELECT DISTINCT salary
FROM employees
ORDER BY salary))
WHERE sl = n

Answer / ajit nayak

SELECT MAX( Sal ), LEVEL
FROM Emp
WHERE LEVEl = &Givelevelno
CONNECT BY PRIOR Sal > Sal
GROUP BY LEVEL;

Write a simple Store procedure and pass parameter to it ?

3 Answers   Keane India Ltd,

How to use group functions in the select clause using oracle?

0 Answers  

What is the difference between a hot backup and a cold backup in oracle?

0 Answers  

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  

What is execute immediate in oracle?

0 Answers  

17. Display the order number and average item cost for each order.

1 Answers   Wipro,

Explain the use of grant option in exp command.

0 Answers  

What do database buffers contain?

0 Answers  

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers  

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

What is recovery manager(rman) backup in Oracle?

0 Answers   MCN Solutions,

Explain integrity constraint?

0 Answers