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
16384 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 you explain an index?

1287

How does sql store data?

925

How do you drop a trigger?

998

tell me about various levels of constraint. : Sql dba

1041

How do you sort in sql?

1034

What is the difference between functions, procedures, and packages in pl/sql?

1061

What is scalar data type in pl sql?

1077

Is stored procedure faster than query?

973

Explain mutating table error.

1214

What is trigger with example?

1106

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2229

Is it possible to read/write files to-and-from PL/SQL?

1109

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1065

Explain alias in sql?

1055

What are the set operators in sql?

1083