Answer / selvaraj v, anna university co

Find the HIGHEST SALARY in Employee Table :
-------------------------------------------

select * from emp where sal=(select max(sal) from emp)
order by empno;


Find the 3'rd HIGHEST SALARY in Emp Table :
-----------------------------------------------

SELECT * FROM EMP e WHERE 3=(SELECT COUNT(*) FROM EMP x
WHERE x.SAL>=E.SAL);

It's e,x are ALIAS NAME of EMP Table.

Answer / noorulahaq

select min(sal) from emp where sal in (
select sal from
( select sal from emp order by sal desc )
where rownum <=3 )

Answer / rohit kumar

select min(sal) from (select sal from emp order by sal
desc) where rownum <= 3

Answer / uday kiran

Its is like Nth highest salary.....


Select * from Employee where salary =
(Select max(Salary) from Employee where salary < (Select max
(Salary) from Employee where
Salary<(Select max(Salary) from Employee where
Salary <…………………………………………… N

Answer / nripesh agarwal

select * from emp where salary=(select distinct salary from
emp order by salary desc limit n,1)


// for Nth highest value put n=N-1....
//for 3rd highest put n=2........

Answer / srinath reddy

select * from emp e1 where 3 = (select count(*) from emp e2
where e1.salary <= e2.salary);

instead of answer we can say this as a solution where we can
find nth also

Answer / imran ansari

find n th highest salary replace n with 1,2,3....to find second,third,fourth........sal
SELECT sal from emp order by sal desc limit 2,1

Answer / nripesh agarwal

select * from emp where salary=(select salary from emp
order by salary desc N,1);


// Put the value for N as for Nth highest salary
// e.g. for 2nd put N=2 , for 3rd put N=3 and so on...

Answer / chandra sekhar

SELECT * FROM EMP e
where 3=(select count(*) from emp
where e.sal<=sal)

Using this correlated subquery we can easily get any one

Answer / kiran

select salary from employees e where 3 = (select count
(distinct salary) from employees f where
e.salary <= f.salary);

What is rownum in sql?

0 Answers  

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

What is user defined functions?

0 Answers  

What is the difference between join and natural join?

0 Answers  

what are the advantages of mysql in comparison to oracle? : Sql dba

0 Answers  

What is sequence in sql?

0 Answers  

What is normalization in a database?

0 Answers  

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

How do you retrieve the last N records from a table?

10 Answers  

what are all the different types of indexes? : Sql dba

0 Answers  

What is a primary key? Explain

0 Answers  

Is vs as in pl sql?

0 Answers