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

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

How do I run a program in pl sql?

0 Answers  

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

What is the purpose of primary key?

0 Answers  

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

how to create temparary sequence

2 Answers   TCS,

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

Does view store data in sql?

0 Answers  

Can a varchar be a primary key?

0 Answers  

how to create a new view in mysql? : Sql dba

0 Answers