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 / menan

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

Answer Posted / menan

COUNT(field) and MAX(field)

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the plv (pl/vision) package offers?

1112

What does pl sql developer do?

980

Which is better varchar or nvarchar?

1050

What is rename command in sql?

1093

Is id a reserved word in sql?

1187

Enlist the advantages of sql.

1052

What pl/sql package consists of?

1133

What is the difference between partition and index?

1055

Difference between global and parameter variables?

2012

what are the different index configurations a table can have? : Sql dba

1042

is mysql query is case sensitive? : Sql dba

1162

What is embedded sql with example?

1096

How we can update the view?

1096

What is rank dense_rank and partition in sql?

1084

What is aggregate function in sql?

1080