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

Explain the importance of .pll extension in oracle?

0 Answers  

How view is different from a table?

0 Answers  

How to connect the oracle server as sysdba?

0 Answers  

How to drop an existing table in oracle?

0 Answers  

What is the relation of a user account and a schema?

0 Answers  

how to store only time in a data base table

2 Answers  

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

1 Answers   ESS,

Explain the use of show option in imp command.

0 Answers  

How do I reset a sequence in oracle?

0 Answers  

What does a Control file Contain ?

2 Answers  

Explain an exception?

0 Answers  

How do I recompile a procedure in oracle?

0 Answers