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);

Is full outer join same as cross join?

0 Answers  

Advantages and disadvantages of stored procedure?

0 Answers  

What is union and union all keyword in sql and what are their differences?

0 Answers  

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

25.67,-1 Trunc = 20 Round= 30 HOW????

2 Answers   Karrox,

what are the advantages of cursors than procedures?

2 Answers  

What is mutating table?

11 Answers   Saama Tech,

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

what are the properties and different types of sub-queries? : Sql dba

0 Answers  

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

What is cartesian join in sql?

0 Answers  

What is lookup table in sql?

0 Answers