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

if you ctreate table identity

0 Answers  

How to create a table interactively?

0 Answers  

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

What is the difference between substr & instr functions?

0 Answers  

how to retrieve data from different tables ,place this data in different excel worksheets.

1 Answers   Gap Inc,

How can we Update a table with out using UPDATE command?

1 Answers  

Find all employees in Dept “Marketing”.

2 Answers  

What is the max number of columns in an oracle table?

0 Answers  

What is the difference between I and G in Oracle?

0 Answers   MCN Solutions,

Explain the dml?

0 Answers  

How to lock and unlock a user account in oracle?

0 Answers  

When do you get a .pll extension in oracle?

0 Answers