COUNT(field) and MAX(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 / menan

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

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

Mention what are the benefits of pl/sql packages?

1080

Can we have two clustered index on a table?

1025

What is loop in pl sql?

1037

Can a procedure in a package be overloaded?

1043

What are the types of keys?

996

What is sql procedures and functions?

1004

What is the starting oracle error number?

1052

What is difference between rank () row_number () and dense_rank () in sql?

1101

Which function is used to return remainder in a division operator in sql?

1139

What is the difference between python and sql?

999

What is crud stand for?

996

What is sqlcontext?

1082

What is user in sql?

1019

what is the difference between $message and $$message? : Sql dba

997

How to display Row Number with Records in Oracle SQL Plus?

1047