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)

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 does (*) mean in sql?

537


What type of join is sql join?

545


what is cross join? : Sql dba

584


What is hibernate and its relation to sql?

600


Define the select into statement.

584






Which data type is a composite type?

549


What are the advantages of sql? Explain

667


Why are indexes and views important to an organization?

533


What is the difference between left outer join and left join?

530


Explain what is table in a database?

595


what is oracle database ? : Sql dba

571


Explain normalization and what are the advantages of it?

529


What is difference sql and mysql?

548


Is sqlexception checked or unchecked?

553


What is difference between stored function and application function?

603