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

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

0 Answers  

How to create a table interactively?

0 Answers  

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

How to delete all rows a table in oracle?

0 Answers  

What is Undo Management Advisor in Oracle?

0 Answers   MCN Solutions,

In which language oracle has been developed?

0 Answers  

What is the difference between post-database commit and post-form commit?

0 Answers  

What suggestions do you have to reduce the network traffic?

0 Answers  

State the various uses of dbcc command?

0 Answers  

What happens if you lost a data file?

0 Answers  

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

0 Answers   GTL,

What is currency type in database ?

3 Answers   TCS,