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 use of double ampersand (&&) in sql queries? Give an example

1187

What are transaction and its controls?

1089

What is delimiter sql?

1058

What is a dirty read sql?

1241

What is data type in sql?

1001

what is commit? : Sql dba

1122

What is raid? How does it help storage of databases?

1128

What is the difference between microsoft access and sql server?

1104

Can one improve the performance of sql*loader? : aql loader

1097

Does pl/sql support create command?

1168

How does postgresql compare to "nosql"?

1079

What is the difference between function and procedure in pl/sql?

1135

What is sql partition function?

1287

What is the difference between sql and t sql?

1103

What is cursor and its types?

1147