Answer / biswapratap singh

SELECT MIN(sal) FROM emp WHERE
sal IN (SELECT distinct TOP 3 sal FROM emp ORDER BY sal DESC)

Answer / neha

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

Answer / sanjeev kumar p

select * from emp e1 where (3-1) = (select count(distinct
(e2.sal)) from emp e2 where e2.sal>e1.sal)

Answer / arijit

donno whether the rest are correct ..but this one is:-
select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));

Answer / harmeet

Hi, this query will gives the third highest salary from table

select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);

To dispay 5th highest salary, just change the number 3 to 5.
Like that we can find top N salaries.

I hope i'm not wrong.

Answer / akshita

select * from (select e.*,rownum r from (select distinct
sal from emp order by sal desc) e) where r = 3

Answer / suresh kumar

Hi every body,

I give the standard format Query for this type of top most
and who are the top n people in the organization like that

If we take EMP table

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

If we give n value 1 or 2 or 3….etc then we gets top one,
top second, and top third person details.

This same query can we use top n people who are earning
maximum salaries in the Organization

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

Answer / punit chauhan

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


punit chauhan
iMS NOIDA
doing MCA

Answer / punit chauhan

select * from emp_record e1 where (3-1) = (select count ( distinct (e2.salary)) from emp_record e2 where e2.salary > e1.salary

Answer / selvaraj anna university coe

In ORACLE 10g,

SELECT * FROM employee x WHERE 3 = (SELECT COUNT(DISTINCT
salary)
FROM employee y WHERE x.salary <= y.salary);

Explain the truncate in oracle?

0 Answers  

difference between procedures and function?

7 Answers   IBM,

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

0 Answers   MCN Solutions,

How to pass a parameter to a cursor in oracle?

0 Answers  

write a query that displays every Friday in a year with date?

5 Answers   Flipkart, HCL, TCS,

Explain the relationship among Database, Tablespace and Data file?

4 Answers  

Which dictionary tables and/or views would you look at to diagnose a locking issue?

0 Answers  

Is java required for oracle client?

0 Answers  

How can we view last record added to a table?

0 Answers  

26. Display the earliest shipping date in the format: DD/MON/YYYY

5 Answers   Wipro,

How many types of tables supported by oracle?

0 Answers  

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers