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

what is a relationship and what are they? : Sql dba

749


Is sql a case sensitive language?

706


Is it mandatory for the primary key to be given a value when a new record is inserted?

931


Can we use pl sql in sql server?

739


Can we write dml inside a function in sql server?

675






how to convert character strings to numeric values? : Sql dba

771


Why is nosql good?

777


tell me about various levels of constraint. : Sql dba

759


what is view? : Sql dba

728


How do you declare a user-defined exception?

718


How is data stored on a disk?

726


What is difference between hql and native sql?

777


what are string data types? : Sql dba

701


what is datawarehouse? : Sql dba

751


What does <> sql mean?

712