Answer / k.prashanth

Select
ename,sal,deptno
from emp
where sal in
(select max
(sal) from emp
where
level<=5
connect by
prior sal<sal
group by level)

Answer / manoranjan sethy

Method 01:
---------
Select Ename, MAX (Sal) From Emp
Group by ROWNUM, Ename
Having Rownum <=5;

Answer / vivek dubey

this Query is wrong : " SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC ) WHERE ROWNUM<6; " because We can not use Order by clause in SubQuery.

This Answer gives you the right data :

"
SELECT TOP 5
empsal.ENAME,
empsal.SAL
FROM
(
SELECT ENAME,SAL
FROM EMP
) AS empsal
ORDER BY empsal.SAL DESC
"

Answer / ajay dond

select salary from (select distinct salary from employees
order by salary desc)
where rownum<6

Answer / ram

select ename,salary from(select ename,salary from emp order by salary desc) where rownumber<6

Answer / kishore

select salery from (select salery from
emp order by salery desc) where rownum <=5 ;

Answer / manjunath u

select salary from(select salary from emp order by salary
desc)where rownum<=5;

Answer / alex, n.y [microsoft]

SELECT TOP 5 [SALARY] FROM [EMP]

Answer / kavitha nedigunta

select a.*
from(select empno,ename,sal
from emp
order by sal desc nulls last)a
where rownum <6
order by sal desc

Answer / mohammad murtuza ali

select * from emp as(empname,empsal,empdesc) where rownum<6

Are subqueries faster than joins?

0 Answers  

What does dml mean?

0 Answers  

what is denormalization. : Sql dba

0 Answers  

Can I call a procedure inside a function?

0 Answers  

How does an execution block start and end in pl sql?

0 Answers  

Can we edit a view in sql?

0 Answers  

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

What is java sql connection?

0 Answers  

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

What is the difference between sum and count in sql?

0 Answers  

how to get enames with comma seperated values by deptwise on emp table?

8 Answers