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
16346 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

How much ram can sql express use?

985

Explain the working of primary key?

1098

Can we use ddl statements in stored procedure sql server?

1009

How to run sql statements through the web interface?

1041

What is rank () in sql?

941

What is the cause of mutating table error and how can we solve it?

1049

How do I turn a list into a table?

961

explain the advantages and disadvantages of stored procedure? : Sql dba

1009

How do you write an index?

965

what are wild cards used in database for pattern matching ? : Sql dba

1143

when is the use of update_statistics command? : Sql dba

1049

What are joins in sql?

1044

What is break?

1197

what is index? : Sql dba

1005

Can you have a foreign key without a primary key?

955