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 install oracle odbc drivers?

0 Answers  

hai, when to use char and varchar2....?

2 Answers  

How to write a query with a right outer join in oracle?

0 Answers  

Write query to fetch second maximum salary from employee table.

4 Answers   Bravura Solutions, HCL,

Explain constraining triggers.

0 Answers  

What is Redo Log Buffer in Oracle?

0 Answers   MCN Solutions,

How does one get the view definition of fixed views/tables?

0 Answers  

What is Hash Cluster ?

2 Answers  

 How to use an oracle sequence generator in a mapping?

0 Answers   Informatica,

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

what is insert all statement in sql

2 Answers   CGI, TCS,

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,