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
16589 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 do you truncate?

954

Is left join inner or outer by default?

1072

What is a record in pl/sql?

1216

What is the difference between a primary key and a clustered index?

1035

What does truncate mean in sql?

1082

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

1115

What is pivot in sql?

971

What is varray in pl sql?

1120

What is a database? Explain

1176

how to use like conditions? : Sql dba

1164

Is primary key clustered index?

992

What are the types of records?

1035

Can we use threading in pl/sql?

1091

how many sql ddl commands are supported by 'mysql'? : Sql dba

1064

Does asenumerable execute the query?

1095