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

What is keys and its types?

1 Answers  

How do I count records in sql?

1 Answers  

How do I run pl sql in sql developer?

1 Answers  

Can we call a function containing dml statements in a select query?

1 Answers  

What is query optimization in sql?

1 Answers  

what is a view? : Sql dba

1 Answers  

What are the types of SQL Statement?

3 Answers  

how to retrieve only duplicate values in a table

9 Answers  

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

What is minus?

1 Answers  

What is trigger with example?

1 Answers