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

How to define a sub function?

0 Answers  

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

Can the query output be sorted by multiple columns in oracle?

0 Answers  

How to update values on multiple rows in oracle?

0 Answers  

How many different types of indexes we have in oracle?

24 Answers   IBM, TCS,

What is Reduced List of Values?

0 Answers   iFlex,

What is the difference between 10g OEM and 11g OEM?

0 Answers   MCN Solutions,

When can Hash Cluster used ?

1 Answers  

What are the different types of trigger and explain its various uses and functions?

0 Answers  

What are transaction isolation levels supported by oracle?

0 Answers  

What are the different pseudo commands? Explain in general?

0 Answers  

How to omit columns with default values in insert statement in oracle?

0 Answers