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

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

1150

What is trigger in pl sql with examples?

1020

Is it possible to sort a column using a column alias?

1034

Can a view be mutating? If yes, then how?

1011

How delete all data from all tables in sql?

939

How to run sql functions in pl/sql?

1047

What is ttitle and btitle?

1057

What is the meaning of disabling a trigger?

1163

Explain polymorphism in pl/sql.

1110

What is the use of <> sql?

970

What is a database trigger?

1061

What is cold data?

945

Can sql function call stored procedure?

1007

Is join and inner join the same?

998

What is the difference between a database and a relational database?

1094