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)
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
Which constraints we can use while creating database in sql?
Can we rename a column in the output of sql query?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is the difference between microsoft access and sql?
What is pl sql script?
How do I create a memory optimized filegroup?
What is the difference between having and a where in sql?
What is difference between procedure and trigger?
How to change the order of columns in Oracle SQL Plus ?
Can a primary key be a foreign key?
what is table? : Sql dba
What is the purpose of normalization?
What is cte?
What are commit, rollback, and savepoint?
How do you write an inner join query?