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

How many row comparison operators are used while working with a subquery?

1030

How to handle bulk data?

1308

What are the qualities of 2nf?

1035

Can you join views in sql?

951

What is asqueryable?

965

What is dialect in sql?

942

What is record type in pl sql?

984

Write an sql query to select all records from the table?

1026

what is the different between now() and current_date()? : Sql dba

1016

What are the sql aggregate functions?

1122

What is varchar sql?

1132

how to convert character strings to dates? : Sql dba

1056

What are the types of views in sql?

1092

how to see the create table statement of an existing table? : Sql dba

1007

What does desc stand for?

1065