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
16580 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

Can we rename a column in the output of sql query?

1038

How do I turn a list into a table?

1007

What is data types in sql?

1070

What are synonyms in sql?

1017

how to create a new view in mysql? : Sql dba

986

How to pronounce postgresql?

1095

What is on delete restrict?

1067

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1221

What is right join in sql?

1151

What is pl sql package?

1071

What is pivot table in sql?

1167

How do you delete duplicates in sql query using rowid?

984

How to check if a column is nullable before setting to nullable?

1176

Which is faster subquery or join?

1267

What is partition by in sql?

1125