select max(salary) from (select distinct(salary) from ABC)

Name Salary
Abc 50000
Abc 50000
xyz 20000
find the max salary using aggregate function?

Question Posted / prashant

Answer Posted / prashant

select max(salary) from
(select distinct(salary) from ABC)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the difference between cluster and non cluster index? : Sql dba

954

How to change sql*plus system settings?

994

What is difference between group by and partition by?

976

How to install oracle sql developer?

983

Is pl sql a programming language?

924

What is the maximum size of sqlite database?

1039

Explain the difference between 'between' & 'and' operators in sql

944

what are the types of join and explain each? : Sql dba

989

what is a record in a database ? : Sql dba

994

How can I get the number of records affected by a stored procedure?

999

Is it possible to pass parameters to triggers?

1029

Does sql*plus also have a pl/sql engine?

1036

What is trigger point?

949

explain access control lists. : Sql dba

946

What does partition by mean in sql?

907