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
16234 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 turn a list into a table?

944

What is linq to sql?

1120

which operator is used in query for pattern matching? : Sql dba

985

Enlist the data types that can be used in pl/sql?

1047

What does where 1/2 mean in sql?

1048

How can you create an empty table from an existing table?

1057

What is difference between my sql and sql?

1044

What is a boolean in sql?

965

How to find 3rd highest salary of an employee from the employee table in sql?

1060

Can we create index on primary key?

949

how is exception handling handled in mysql? : Sql dba

1061

What is the sql*loader? : aql loader

1039

Why is there a need for sqlcode and sqlerrm variables?

1029

Can we enter data in a table in design view?

951

What is the difference between null value, zero, and blank space?

1185