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
16587 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 meaning of <> in sql?

1129

What is a loop in sql?

1035

Is join same as left join?

1080

What is difference between db2 and sql?

1046

What do you think about pl/sql?

1121

What are packages in pl sql and also explain its advantages?

1122

What is meant by temporal data?

1000

how to enter binary numbers in sql statements? : Sql dba

1011

what is a materialized view? : Sql dba

1128

What is difference between stored function and application function?

1289

What is a table?

1057

How do I get sql certification?

1017

Can you do multiple joins in sql?

1117

What is user in sql?

1073

Where not exists in sql?

1032