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 / santhosh , hyd

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

Answer Posted / santhosh , hyd

COUNT(field) and MAX(field)

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I upgrade sql?

987

How many scalar data types are supported in pl/sql?

1028

Why is sql*loader direct path so fast?

1091

Explain exception handling in pl/sql?

1021

What are the different types of a subquery?

1034

Does mysql support pl sql?

1144

How can we link a sql database to an existing android app?

1014

What is the difference between partitioning and sharding?

990

What are all the different types of indexes?

1127

Does truncate require commit?

955

What is sqlcommand?

1010

What is basic structure of pl sql?

1050

What is trigger explain with example?

1016

Are dml statements autocommit?

1029

Is nosql faster than sql?

1001