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

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

Question Posted / deepikavani

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 / rushi

select ename from employee where sal=(select disinct(max(sal) from employee));

Is This Answer Correct ?

2 Yes

8 No

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

Answer / rohit

SELECT ENAME,SAL FROM EMP
WHERE ROWNUM = 1
ORDER BY SAL DESC

Is This Answer Correct ?

0 Yes

7 No

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

Answer / shan

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

Is This Answer Correct ?

0 Yes

8 No

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

select Name from emp where sal=(select distinct(Max(sal))
from emp

Is This Answer Correct ?

4 Yes

14 No

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

Answer / hari.sidd

SELECT ENAME
FROM EMPLOYEE
WHERE ESAL=MAX(ESAL);

Is This Answer Correct ?

1 Yes

12 No