Answer / hanumantha r challa

select * from emp a where &n=(select count(b.sal) from emp
b where b.sal>=a.sal);

Answer / raghav

select * from (
select Name,
Salary,
Dept,
Rank()over (order by salary desc) RANK
from Employee)
where RANK = 3

Answer / joel

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

Answer / sudesh indore

select ( salary) as sal from employee ORDER by
salary DESC limit 2,1

------------
i hope that will help u thanx

Answer / esha gautam

SELECT SAL FROM EMP E WHERE &N-1 =(SELECT COUNT(*) FROM EMP
WHERE E.SAL<SAL);

HERE N FOR NTH SALARY!!!!!!!!!!!!!!!!!!!!

Answer / amrish singh

this is the query for retrieving nth highest salary from
table emp
select e.sal
from emp e
where n-1=(select count(*) from emp s where s.sal>e.sal)

putting the value of n we get the required result.

Answer / venkatranjith e

Hi All,

This query will give you the o/p.

Select * from EMP A where &n= (select count (distinct
(sal)) from EMP B where B.sal>A.sal)

n = 3 , to display 3rd largest salary.

Answer / vishawjeet saini

SELECT MIN(sal) FROM emp WHERE
sal IN (select sal from emp order by sal desc limit 3)

Its works on almost databases including postgres.

Answer / amit singh

forget the book first
Empsal table data
700
500
100
900
400
200
600
750


query to find second highest salary from table Empsal

mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<(select max(salary) from Empsal));

Output=750



query to find third highest salary from table Empsal


mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<
>(select max(e1.salary) from Empsal e1
>where e1.salary IN(
>select e2.salary from Empsal e2 where
>e2.salary<(select max(salary) from Empsal))));
Output=700
don't args without run
amitsing2008@gmail.com(amy is back again)

Answer / arungkd

Hey dudes ,

i have worked out this question and got the Answer.... here
it is given below...

SELECT min(income) AS salary FROM [user] WHERE income in
(SELECT DISTINCT top 3 income FROM [user] order by income
desc )

Display the number value in Words?

1 Answers  

What is define in oracle?

0 Answers  

how to store only time in a data base table

2 Answers  

Differentiate between pre-select and pre-query?

0 Answers  

What are the built-in functions used for sending Parameters to forms ?

0 Answers   Oracle, TCS,

What are the attributes of the cursor?

0 Answers  

What is the maximum number of triggers that can be applied to a single table?

0 Answers  

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 Answers  

What are the types of synonyms?

1 Answers  

Why cursor variables are easier to use than cursors?

0 Answers  

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

1 Answers   Infosys,

Describe an oracle table?

0 Answers