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
24690 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 / kanhu charan biswal

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

For see the max(sal) with ename departmentwise the query
will be:
select ename,sal from emp a
where sal in (select max(sal) from emp group by deptno);

For findout the nth highest salary with name, the query
will be:

select ename,sal from emp a
where &n=(select count(distinct sal) from emp b
where b.sal>=a.sal)
after execute the query it will ask you to pass a value
for 'n'.it stands for nth hiest salary

Is This Answer Correct ?

0 Yes

0 No

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

Answer / binod singh

SELECT max(Distinct sal),ename
FROM emp
/

SQL> select max(distinct salary) from employees;

MAX(DISTINCTSALARY)
-------------------
24000

Is This Answer Correct ?

3 Yes

5 No

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

Answer / ahmad nazmi

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

Is This Answer Correct ?

1 Yes

3 No

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

Answer / madhav

select ename from emp where sal=(select max(sal) from emp);
ENAME
---------
KING

--first execute the inner query like
select max(sal) from emp;
MAX(SAL)
---------
5000
--- after that salary value pass the outer query like
this
select ename from emp where sal=5000
ENAME
---------
KING

Email:thota.madhav@gmail.com

Is This Answer Correct ?

2 Yes

6 No

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

Answer / suresh kumar somayajula

SELECT ename,MAX(sal)
FROM EMP
GROUP BY ename;

Is This Answer Correct ?

9 Yes

15 No

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

Answer / ahmad nazmi

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

Is This Answer Correct ?

4 Yes

11 No

Post New Answer