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 / santhosh , hyd

COUNT(field) and MAX(field)

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql performance tuning?

497


Is sql port 1433 encrypted?

578


what is 'mysqlshow'? : Sql dba

593


write an sql query to find names of employee start with 'a'? : Sql dba

584


Is it possible to link two groups inside a cross products after the cross products group has been created?

599






define sql update statement ? : Sql dba

584


How do I pipe the output of one isql to another?

536


how to select first 5 records from a table? : Sql dba

511


How many parts of a pl sql block are optional?

523


How do you rank data in sql?

517


How does sql profiler work?

574


What is sql in java?

549


what is column? : Sql dba

576


What is secondary key?

514


Explain the the delete statements in sql?

581