Answer / girija.112

ANS :
select max(ename) keep (dense_rank last order by sal) ename
from emp

ENAME
-----
KING

Answer / srinu.g

select b.ename from emp b,(select max(sal) k from emp) a
where a.k=b.sal;

Answer / naidu

SELECT * FROM Emp
WHERE LEVEL=&Number
CONNECT BY PRIOR Sal > Sal ;

Answer / naresh

Here is the solution.

Select E_id, E_name,Salary from the Employes group by E_ID
Having Salary=Max(Salary)

Should work.
Try it and let me know.

Cheers!
Naresh

Answer / niladri chatterjee

Select * From (Select * From Employee Order By Salary Desc) a
Where rownum=1 ;

Or

Select * From (Select Emp_id, Emp_NM, Salary From Employee Order By Salary Desc) a
Where rownum=1 ;

Based on Oracle 11g.

Answer / flitchner

select name from (select max(sal) as salary from emp) a,
emp b
where a.salary = b.sal;

Answer / neha

select a.ename from (select ename from emp ORDER BY SAL
desc,ROWNUM DESC)a
where rownum=1;

Answer / lince

select top 1 Name from emp order by sal desc

Answer / atal patra

select ename,max(sal)from emp group by ename;

Answer / pavan

select * from (select ename from emp order by rownuum desc)
where rownum=1;

What does `(+)` do in a where clause?

1 Answers  

How many types of database triggers exist?

0 Answers  

Shall I get Pro*C Compiler in Oracle-10g release ?

1 Answers  

What are the built-in functions used for sending Parameters to forms ?

0 Answers   Oracle, TCS,

What is the fastest query method to fetch data from the table?

0 Answers  

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

what is pragma?

2 Answers  

Explain compound trigger in oracle?

0 Answers  

What is different types of joins?

0 Answers  

What is difference between Rename and Alias?

1 Answers  

Please explain compound trigger in oracle?

0 Answers  

What are privileges and grants?

0 Answers