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

What is benefit of creating memory optimized table?

906

What is a stored procedure in sql with example?

1052

Can we create a trigger on view?

839

Is it possible to include an insert statement on the same table to which the trigger is assigned?

955

Why do we need cursor in pl sql?

1077

Which one is better sql or oracle?

898

Can we insert in view in sql?

999

What is composite primary key in sql?

936

what are the differences between char and varchar? : Sql dba

1000

How do I kill a query in postgresql?

1010

What is the starting oracle error number? What is meant by forward declaration in functions?

936

what is an alias command? : Sql dba

1006

Sql technical questions

1196

What is pl sql block structure?

973

what is sql server agent? : Sql dba

1027