HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / 11/14/2008

16 Answers
19948 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / pramod janjirala

select sal,ename from emp where sal=(select max(sal) from
emp);

Is This Answer Correct ?

32 Yes

7 No

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / chandu

select ename,sal from emp where sal=(select max(sal) from emp);

Is This Answer Correct ?

12 Yes

3 No

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / ram

select sal as Max_sal, ename from emp where sal
IN( select max(sal) from emp);

sun_ramprasad@yahoo.com

Is This Answer Correct ?

5 Yes

0 No

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / suresh naik

select sal, ename from emp where sal = (select max(sal) from
emp);

Is This Answer Correct ?

4 Yes

0 No

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / pramod janjirala

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

Is This Answer Correct ?

13 Yes

10 No

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / kavitha

select ename,sal
from employees
where rownum <=1
order by sal desc

Is This Answer Correct ?

2 Yes

0 No

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / manoj k

select distinct sal,ename from emp
where sal=(select max(sal) from emp);

Is This Answer Correct ?

2 Yes

0 No

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / nagendra

select ename, sal from emp where sal = (select max(Sal) from
emp);

Is This Answer Correct ?

1 Yes

0 No

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / selvaraj v , anna university c

select ename, salary from emp where salary=(select max
(salary) from emp) order by emp_no;

Is This Answer Correct ?

1 Yes

0 No

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE...

Answer / santosh

select ename,sal
from emp
where sal = (select max(sal) from emp)
and rownum<= 1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer