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

16 Answers
24061 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can a varchar be a primary key?

955

Is sql scripting language?

975

Why is theta join required?

1081

what is msql? : Sql dba

943

What is the purpose of normalization?

997

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2022

what is sql in mysql? : Sql dba

1123

What is indexes?

1002

How many sql are there?

925

What are the different parts of a package?

1043

What are the various levels of constraints?

1061

what is the functionality of the function htmlentities? : Sql dba

894

What is the basic structure of an sql?

1033

What is the difference between a primary key and a unique key?

1001

Is sql an operating system?

963