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
16599 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

How does sql store data?

959

Explain the significance of the & and && operators in pl sql.

1048

What is acid property in a database?

1086

What is the use of prepared statement?

1073

Explain exception handling in pl/sql?

1083

What are the benefits of pl/sql packages?

1157

What can sql server reporting services do?

1164

what is the use of friend function? : Sql dba

1061

Explain what is rdbms?

1086

What is record in pl sql?

1140

What is self-join and what is the requirement of self-join?

1192

What is update query?

1033

what is a composite primary key ? : Sql dba

1095

What are sql objects?

1129

Is inner join same as self join?

1168