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

COUNT(field) and MAX(field)

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write the alter statement to enable all the triggers on the t.students table.

848


What is the source code of a program?

709


What are different clauses used in sql?

813


Can we use having without group by in sql?

732


How do you declare a variable in pl sql?

746






what is dbms? : Sql dba

736


What is the most common sql injection tool?

739


Can a composite key be null?

713


Explain some predefined exceptions.

778


Which language is used in sql?

730


How to select all records from the table?

804


How do I run a sql trace?

692


What is number function in sql?

709


What is the difference between a primary key and a clustered index?

697


What is compound trigger?

754