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

Is null operator in sql?

985

What is sql and also describe types of sql statements?

1008

What is crud sql?

930

What is sql architecture?

998

what is the difference between a having clause and a where clause? : Sql dba

1016

Is pl sql different from sql?

944

explain primary keys and auto increment fields in mysql : sql dba

906

Is sql between inclusive?

1073

Is there any restriction on the use of union in embedded sql?

1116

What is a parameter query?

1030

how to show all tables with 'mysql'? : Sql dba

1067

What does the acronym acid stand for in database management?

991

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1120

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1156

What is on delete restrict?

953