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
16015 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 are the types of views in sql?

1041

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

903

Describe types of sql statements?

994

What is output spooling in sql*plus?

986

Can we create a trigger on view?

844

what is the difference difference between procedure and packages

10251

How many commands are in sql?

1003

How do I debug a stored procedure?

1042

which operator is used in query for pattern matching? : Sql dba

949

Can we use view in stored procedure?

865

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1037

how to dump a table to a file with 'mysqldump'? : Sql dba

983

What is a sql trace file?

978

What are the different types of triggers?

1056

What are the query optimization techniques?

888