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
16347 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 java sql drivermanager?

1093

What is bulk compiling in pl/sql.?

1129

What is relationship? How many types of relationship are there?

1183

How global cursor can be declare with dynamic trigger ?

2210

What's the difference between a primary key and a clustered index?

986

How to combine two stored procedures in sql?

1237

What is a ddl command?

1087

What is trigger explain with example?

1039

What is a memo field?

969

Is sqlite free?

971

What is the difference between jpql and sql?

1095

What is full join?

953

Can we use pl sql in mysql?

1013

Do we need commit after truncate?

1079

What is varchar sql?

1140