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 schema-level triggers?

1155

How does cross join work in sql?

1079

What are actual parameters and formal parameters?

1178

What is the use of prepared statement?

1076

How do I add a database to sql?

1185

What are sql injection vulnerabilities?

1027

How do you update sql?

1038

What is thread join () in threading?

1057

Are stored procedures compiled?

980

What are different types of tables in sql?

1052

What is graph sql?

1039

Is pl sql a programming language?

1045

Explain about various levels of constraint.

1000

What is sql and explain its components?

1119

What is the source code of a program?

1120