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)
- 6 Answers
- 15005 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
What is sqlexception in java?
What is multiple partition?
What is the use of pl/sql table?
How to pipe multiline string to isql?
What is prepared statement in sql?
What found sql?
What are the different type of joins in sql?
Explian rowid, rownum? What are the psoducolumns we have?
What is the meaning of disabling a trigger?
Is sql similar to python?
What is pl sql record in oracle?
What are the possible values that can be stored in a boolean data field?
What does <> sql mean?
What is the difference between microsoft access and sql?
Why use truncate instead of delete?
