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 are the join types in tsql? : Transact sql

1019

What is assignment operator in pl sql?

996

what is transaction? : Sql dba

975

What is a full join sql?

1002

How do I find duplicates in two columns?

1097

Why do we use procedures?

930

What is the most important ddl statements in sql are?

967

What is primary key secondary key alternate key candidate key?

1003

What is self-join and what is the requirement of self-join?

1114

What does data normalization mean?

920

How do I filter in sql profiler?

967

Why is normalization important?

993

Explain how exception handling is done in advance pl/sql?

973

Can we use joins in subquery?

1110

Does sql support programming?

1027