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

What do you understand by case manipulation functions?

1040

what is cursor. write example of it. What are the attributes of cursor.

1399

What is synonyms?

1063

What is difference between stored function and application function?

1209

How do I run a sql query?

1028

What is pl sql commands?

1049

Enlist the data types that can be used in pl/sql?

1074

What is dialect in sql?

954

What is the use of sql trace?

957

What does subquery mean in sql?

1058

How much does sql certification cost?

1095

How does cross join work in sql?

1022

how do you tune the slow running queries in oracle db , explain the methodology

2824

what is data integrity? : Sql dba

1043

How can you tell the difference between an index and a view?

937