1)THE COUNT(field) and MAX(field) CAN BE USED WITH CHARACTER FIELDS

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

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

Answer Posted / tulsi

1)THE COUNT(field) and MAX(field) CAN BE USED WITH
CHARACTER FIELDS

Is This Answer Correct ?

14 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I count duplicates in sql?

1098

How can check sql version from command line?

1077

How to get help at the sql prompt?

1109

How can the performance of a trigger be improved?

1035

Are sql connections encrypted?

1016

What is the use of function "module procedure" in pl/sql?

1189

How many types of literals are available in pl sql?

1109

Which is better join or inner query?

1035

Is primary key always clustered index?

1013

how to use 'mysql' to run sql statements? : Sql dba

1045

Define commit?

992

Why do we use joins?

1031

What is sql integrity?

1142

What are the types of join in sql?

1092

what is dbms? : Sql dba

985