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 are various joins used while writing SUBQUERIES?

2 Answers  

How to write an inner join with the where clause in oracle?

0 Answers  

What is bulk load in oracle?

0 Answers  

How to update values on multiple rows in oracle?

0 Answers  

What is the difference between a primary key & a unique key?

0 Answers  

Is it possible to split the print reviewer into more than one region ?

0 Answers   Oracle,

What is a read write transaction in oracle?

0 Answers  

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

Explain self joins in oracle?

0 Answers  

Explain about your project and its relation to the current job position you are applying to?

0 Answers  

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers  

How to add another datafile to a tablespace?

0 Answers