Answer / sunil panghal

select rownum as row_id,salary from (select salary from
employees order by salary) where rownum <6;

Answer / rammohan

select rownum as row_id,sal from (select sal from
emp order by sal desc) where rownum <6;

Answer / uttam

select sal from (SELECT distinct sal FROM emp order by sal
desc)
where rownum <6

Answer / manjusure@yahoo.co.in

select * from emp e where 5> (select count(max(sal)) from emp
where e.deptno=deptno and sal>e.sal group by sal);

Answer / mihir nasikkar

select *
from employee X
where salary in (select top 5 salary
from employee
where dept = X.dept
order by salary desc)
order by dept, salary desc

Answer / mangesh

SELECT * FROM (SELECT * FROM EMP ORDER BY SALARY desc) WHERE ROWNUM < 6;

Answer / md valiyullah

select max(sal)-5 from emp;

Answer / md valiyullah

select max(sal)-5 from emp where dept = 'sale'
union all
select max(sal)-5 from emp where dept = 'purchase'

Answer / dhanalakshmi

select salary
from employee
where rownum<6
group by deptno,salary
order by salary desc

Answer / tytry

ytytry

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

1 Answers   Arrow Electronics,

Can we create trigger on view in oracle?

1 Answers  

What are the types of trigger in oracle?

0 Answers  

What are the ways tablespaces can be managed and how do they differ?

0 Answers  

am completed mca2011 how get certification in oracle

1 Answers  

How to connect to oracle using service name instead of sid?

0 Answers  

how to find full database size

1 Answers   BirlaSoft, Consultancy,

What is a lookup table in oracle?

0 Answers  

How to define an oracle sub procedure?

0 Answers  

How to calculate date and time differences in oracle?

0 Answers  

How do we switch from init.ora file to asp file?

2 Answers  

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

0 Answers