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 / santhosh , hyd

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

Answer Posted / santhosh , hyd

COUNT(field) and MAX(field)

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why query optimization is needed?

931

Why do we use view in sql?

972

What is sql exception?

977

What is the difference between truncate and drop statements?

1195

What is varchar sql?

1152

What are pl/sql cursors?

1058

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1117

How bulk collect improves performance?

1013

what is a materialized view? : Sql dba

1068

Is sql easier than java?

1021

What is normalization? How many normalization forms are there?

1091

What do you understand by pl/sql cursors?

1093

What is before trigger?

1007

How do I find duplicates in two columns?

1175

Is oracle and sql same?

1019