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

Do foreign keys improve performance?

543


How to place comments in pl/sql?

602


how do you know if your mysql server is alive? : Sql dba

593


Why is sql better than hql?

504


what is 'mysqldump'? : Sql dba

570






How can we make an if statement within a select statement?

539


Is pl sql a programming language?

546


What is difference between stored procedures and application procedures?

567


what is csv? : Sql dba

572


What is a Mapplet?

643


How can we link a sql database to an existing android app?

546


Explain what is a subquery ?

654


Is there a 64 bit version of ssms?

516


What is pl/sql table? Why it is used?

556


What is recursive join in sql?

546