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 variables in pl sql?

1147

What is auto increment feature in sql?

1111

How to change sql*plus system settings?

1043

explain mysql aggregate functions. : Sql dba

974

how many tables will create when we create table, what are they? : Sql dba

1057

how can you see all indexes defined for a table? : Sql dba

978

How do I install microsoft sql?

1031

What does the acronym acid stand for in database management?

1023

What is the difference between left outer join and left join?

980

What is difference between function and trigger?

1027

Mention what does plv msg allows you to do?

1100

What is the example of procedure?

912

How global cursor can be declare with dynamic trigger ?

2192

What is t sql used for?

1006

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3559