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

What are sql indexes?

541


What is varchar data type in sql?

514


What is trigger and how to use it in sql?

536


Are stored procedures faster than queries?

522


what is sql profiler? : Sql dba

583






what is offset-fetch filter in tsql? : Transact sql

531


What is sql procedures and functions?

531


What is difference between ms sql and mysql?

474


What are the disadvantages of file system?

617


How does pl sql work?

520


What is trigger in pl sql?

556


What is procedure and function in sql?

531


What is the mutating table and constraining table?

556


Explain the difference between rename and alias?

543


What is asqueryable?

529