You can use COUNT(field),MIN(field),MAX(field) functions for character fie

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 / sanjeev

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

Answer Posted / sanjeev

You can use COUNT(field),MIN(field),MAX(field) functions for
character fields.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the left table in sql?

913

What is sql and also describe types of sql statements?

994

Can a primary key be a foreign key?

968

How many triggers can be applied to a table?

993

What is compilation error in pl sql?

920

What is difference between cursor and trigger?

1017

Can a composite key be null?

909

Which kind of parameters cannot have a default value in pl sql?

1070

Write a query to display the current date in sql?

967

How do I kill a query in postgresql?

1011

What are different categories of sql commands?

1067

How can we solve sql error: ora-00904: invalid identifier?

1164

What are synonyms in sql?

929

What is a function in oracle pl sql?

975

What is attribute indicator in pl sql?

958