Answer / shiv prakash

select salary from(select rownum as r,salary from(select
rownum,salary from emp order by salary
desc))where r=2;

Answer / annada

SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary


that will return 2nd highest salry .if we place insted of 1
as 2 then we can get 3 rd highest salary .

Answer / chaitanya pathak

select max(salary) from employee
whrere salary<(selsect max(salary) from employee)

Answer / sandeep

select max(sal) from emp where sal<(select max(sal) from emp);

Answer / anitha

select min(salary)
from (select distinct salary
from employee
order by salary desc)
where rownum <= 2

Answer / radhiv kumar

PROC SQL;
SELECT MAX(SALARY) FROM RIGHTMER1
WHERE SALARY < SELECT MAX (SALARY)FROM RIGHTMER1;
QUIT;

Answer / naveen

selec * from emp e1 (n-1)=(select count(distinct(sal) from
emp e2 where e1.sal<=e2.sal))

Answer / raghu

second highest salary department wise query would be this

select e.dept_id,e.salary,e.emp_name,e.rank from (select
dept_id,emp_name,salary,dense_rank() over (partition by
dept_id order by salary desc nulls last) rank
from employee)e
where e.rank = 2

Answer / thananjayan

SELECT * FROM 'emp` WHERE salary < ( SELECT max( salary
)FROM emp ) ORDER BY salary DESC LIMIT 1

This is Mysql syntax, if you use Oracle just remove LIMIT 1
and put it ROWNUM=1;

Answer / ishrat ali

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

Explain compound trigger in oracle?

0 Answers  

what is meant by magic query

0 Answers  

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

1 Answers  

What is SYSTEM tablespace and When is it Created?

2 Answers  

what is null value?

11 Answers   KITS, Oracle,

Explain temporal data types in oracle

0 Answers  

How to do clean up if create database failed?

0 Answers  

What is currency type in database ?

3 Answers   TCS,

How to estimate disk space needed for an export job?

0 Answers  

Write a trigger example in oracle?

0 Answers  

What are Clusters ?

5 Answers   Amdocs, Infosys,

How to write an inner join with the where clause in oracle?

0 Answers