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
- 14605 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
Is trigger a stored procedure?
What is varray in pl sql?
What does joining a thread mean?
How many primary keys can a table have?
What is the difference between join and natural join?
What is a primary key called that is made up of more than one field?
What are different types of queries in sql?
what is the difference between join and union? : Sql dba
What is graph sql?
Does mysql_real_escape_string prevent sql injection?
What is the max nvarchar size?
how many values can the set function of mysql take? : Sql dba
How many databases can sql express handle?
How do you optimize a stored procedure in sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
