COUNT(field) and MAX(field)

Which one of the following pairs of aggregate functions do
you use with character fields?

1. COUNT(field) and MAX(field)
2. AVG(field) and COUNT(field)
3. MIN(field) and SUM(field)
4. AVG(field) and MAX(field)
5. COUNT(field) and SUM(field)

Question Posted / santhosh , hyd

6 Answers
16294 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / santhosh , hyd

COUNT(field) and MAX(field)

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the sql case statement?

987

Is sql easier than java?

1004

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

969

What is pl sql block structure?

1034

How many types of triggers exist in pl/sql?

1063

How many triggers can be applied to a table?

1054

How many subqueries can be nested in a statement?

979

What is a left inner join?

1011

What are operators available in sql?

1037

Explain autonomous transaction.

1152

Can a varchar be a primary key?

1005

What problem one might face while writing log information to a data-base table in pl/sql?

1153

Why we use joins in sql?

975

what are the advantages a stored procedure? : Sql dba

972

What are two statement types in sql?

1082