COUNT(field) and SUM(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 / paresh

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

Answer Posted / paresh

COUNT(field) and SUM(field)

Is This Answer Correct ?

2 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Difference between truncate, delete and drop commands?

1065

What is the example of procedure?

911

What is sql and its types?

1157

What is error ora-12154: tns:could not resolve the connect identifier specified?

1056

What is the difference between python and sql?

973

What is partition in sql query?

983

What is a database event trigger?

1137

When are we going to use truncate and delete?

965

Can a varchar be a primary key?

994

Write a sql query to convert all character to uppercase after hypen.

1416

Whis is not false in primary key?

1443

What is rename in sql?

955

Is pl sql a programming language?

965

how do you know the version of your mysql server? : Sql dba

987

What is sqlite format?

1174