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

Can group functions be mixed with non-group selection fields?

0 Answers  

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

0 Answers  

What privilege is needed for a user to connect to oracle server?

0 Answers  

Explain an index segment?

0 Answers  

Can a formula column referred to columns in higher group ?

0 Answers   Oracle,

what is meant by magic query

0 Answers  

Explain about achiever in sql?

0 Answers  

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

2 Answers   Wipro,

How many types of database triggers exist?

0 Answers  

What is a subquery in oracle?

0 Answers  

What does ROLLBACK do ?

1 Answers  

1) Does oracle have any table which contain all the exceptions and it's code internally?

0 Answers   CTS,