SELECT max(Distinct sal),ename FROM emp / SQL> select max(distinct

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

Question Posted / binod singh

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is package in pl sql?

1027

Why should I use postgresql?

1018

what is the difference between join and union? : Sql dba

1114

How many types of keys are there in sql?

1040

Can we create a trigger on view?

896

What is composite data type in pl sql?

1114

what are aggregate and scalar functions? : Sql dba

1057

Is sql dba a good career? : SQL DBA

992

What are different types of indexes?

1011

What is nosql vs sql?

1179

What's the difference between inner join and left join?

999

What are the types of keys?

996

What is sql resultset?

989

What does inner join mean?

1169

What packages are available to pl/sql developers?

1059