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

What is the difference between unique and primary key constraints?

1061

what are date and time functions in mysql? : Sql dba

970

how do you login to mysql using unix shell? : Sql dba

1075

What is a pl/sql block?

1212

What do you mean by dbms? What are its different types?

1009

what is a materialized view? : Sql dba

1055

What do you mean by “trigger” in sql?

1066

What are the parts of a sql statement?

1082

How to select unique records from a table?

1051

what is an alias command? : Sql dba

1097

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1134

what is data manipulation language? : Sql dba

1007

Can a procedure in a package be overloaded?

1040

What are local and global Indexes and where they are useful.

1435

Which are sql * plus commands?

1121