How to select the name of employee who is getting maximum sal with out using s

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

How to select the name of employee who is getting maximum
sal with out using subquery

Question Posted / deepikavani

15 Answers
16004 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to select the name of employee who is getting maximum sal with out using subquery..

Answer / girija.112

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

ENAME
-----
KING

Is This Answer Correct ?

8 Yes

4 No

How to select the name of employee who is getting maximum sal with out using subquery..

Answer / srinu.g

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

Is This Answer Correct ?

2 Yes

0 No

How to select the name of employee who is getting maximum sal with out using subquery..

Answer / naidu

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

Is This Answer Correct ?

0 Yes

0 No

How to select the name of employee who is getting maximum sal with out using subquery..

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

Is This Answer Correct ?

0 Yes

0 No

How to select the name of employee who is getting maximum sal with out using subquery..

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.

Is This Answer Correct ?

0 Yes

0 No

How to select the name of employee who is getting maximum sal with out using subquery..

Answer / flitchner

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

Is This Answer Correct ?

0 Yes

1 No

How to select the name of employee who is getting maximum sal with out using subquery..

Answer / neha

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

Is This Answer Correct ?

0 Yes

1 No

How to select the name of employee who is getting maximum sal with out using subquery..

Answer / lince

select top 1 Name from emp order by sal desc

Is This Answer Correct ?

8 Yes

11 No

How to select the name of employee who is getting maximum sal with out using subquery..

Answer / atal patra

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

Is This Answer Correct ?

6 Yes

9 No

How to select the name of employee who is getting maximum sal with out using subquery..

Answer / pavan

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

Is This Answer Correct ?

0 Yes

3 No

Post New Answer