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

Why do we need cursor in pl sql?

658


What are keys in sql?

555


How do you know if a relationship is 2nf?

527


how can we know the count/number of elements of an array? : Sql dba

578


What is sql server and ase?

548






How do you write a subquery?

531


Why primary key is required?

567


When should I use nosql database?

560


What is foreign key and example?

531


What are different types of sql commands?

520


What is sql resultset?

540


What is sqlerrm?

554


What are functions in sql?

517


Explain the difference between triggers and constraints?

530


Which type of cursor is used to execute the dml statement?

540