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

COUNT(field) and SUM(field)

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql a dbms?

536


What are the two types of periodical indexes?

511


Can we debug stored procedure?

527


how to concatenate two character strings? : Sql dba

558


What is sap sql anywhere?

535






Which one is better subquery or joins?

559


What is the usage of the distinct keyword?

692


Which table is left in join?

520


Which constraints we can use while creating database in sql?

619


Does normalization improve performance?

556


Which command is used to call a stored procedure?

505


How do I audit the sql sent to the server?

528


What program will open a mdb file?

505


What is the difference between inner join and left join?

550


how to do backup entire database? : Transact sql

620