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 / menan

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

Answer Posted / menan

COUNT(field) and MAX(field)

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain sql data types?

1085

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

979

What does partition by mean in sql?

955

What is the usage of distinct keyword?

1059

How do I add a database to sql?

1121

What is write ahead logging in sql server?

1042

Is sql difficult?

1148

explain commit and rollback in mysql : sql dba

1006

What is the difference between explicit and implicit cursors in oracle?

1056

Explain the uses of a database trigger?

1035

Name some usages of database trigger?

1016

How do I partition a table in sql?

1120

how to check server status with 'mysqladmin'? : Sql dba

1069

How do I save the results of sql query in a file?

968

What is the difference between microsoft access and sql server?

1048