COUNT(field) and SUM(field)

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)

Question Posted / paresh

6 Answers
15994 Views
HCL, I also Faced
E-Mail Answers

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 does trigger mean in psychology?

911

What is a primary key? Explain

919

What is the difference between sql, mysql and sql server?

1007

How to find 3rd highest salary of an employee from the employee table in sql?

1034

How to download oracle sql developer?

1053

How do you rank data in sql?

933

What are the types of views in sql?

1036

Who is the owner of mysql database?

999

How do you use a while loop in pl sql?

939

What is clustered index in sql?

996

What are the different set operators available in sql?

970

What is the basic form of sql query?

877

How many types of relationship are there?

968

What is nvl?

1018

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

957