Answer / amit bhagat

select min(a.sal) from (select distinct(d.sal) from emp
order by d.sal desc) a where rownum<=5

Answer / venkata

hi, earlier query return sal in asending order and when
duplicate salries are there the earlier highest salary
position returns no rows. I hope this is better query.


select * from (select * from emp order by sal desc)
group by
rownum,empno,ename,job,mgr,hiredate,sal,comm,deptno having
rownum=&n

Answer / aryasen vaikom

SELECT DISTINCT (a.sal)
FROM EMP A
WHERE 5= ( SELECT COUNT (DISTINCT (b.sal))
FROM EMP B
WHERE a.sal<=b.sal )

Answer / venubabu

Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;


sql>Enter value for level:5

Answer / arvind patil

select rownum,name,salary
from (select name,salary
from employee
order by salary desc )
where rownum=5;

Answer / lingareddy

select top 1 salary from (select distinct top 5 salary from emp order by salary desc ) a order by salary asc


if u have any doubts in SQL kindly reach with me,

Thanks & Regards,
Lingareddy.S
sabbasani.reddy1@gmail.com

Answer / vasu

select * from emp a where &nth in(select count(b.sal) from
emp b where b.sal<=a.sal);

Answer / jithendranath.g

select z2.sal from emp z1, emp z2
where z2.sal <=z1.sal
group by z2.sal
having count(z2.sal)=&n

What is a proxy object?

0 Answers  

What is oracle used for?

0 Answers  

What is not equal to in oracle?

0 Answers  

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

How to call a stored function in oracle?

0 Answers  

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

0 Answers  

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

5 Answers  

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

0 Answers  

Please explain the difference between outer join and inner join? With examples would be appreciable..!

6 Answers   IBM,

How to check your oracle database 10g xe installation?

0 Answers  

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,