You can use COUNT(field),MIN(field),MAX(field) functions for character fie

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

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

Answer Posted / sanjeev

You can use COUNT(field),MIN(field),MAX(field) functions for
character fields.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can I speed up sql query?

935

How much does sql certification cost?

1064

What is the purpose of the primary key?

1047

When do we use triggers?

1059

Which normal form is best?

933

What is dml statement?

937

Explain what is table in a database?

1045

What is graph sql?

972

How do I view an execution plan in sql?

965

How to read xml file in oracle pl sql?

897

What is sql select statement?

1013

What does the sign mean in sql?

966

Can we insert data into view?

890

How do you declare a variable in pl sql?

1007

When are we going to use truncate and delete?

964