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

When is the explicit cursor used ?

1085

What are some predefined exceptions in pl/sql?

1218

What are the ddl commands?

1051

How long it takes to learn pl sql?

1062

Is pl sql still used?

1015

Can we create clustered index without primary key?

996

What is database migration?

1006

How to move files from one directory to another in pl sql?

1243

how to rename an existing column in a table? : Sql dba

1074

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1177

I need a function for a train ticket reservation please answer it thanks in advance

1070

What are expressions?

1059

How much ram can sql express use?

1035

Explian rowid, rownum?

1075

How to return multiple rows from the stored procedure?

1012