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
How many indexes can be created on a table in sql?
Why is nosql good?
What are secondary keys?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
tell us something about heap tables. : Sql dba
How do you create an update query?
what is bcp? When is it used?
Is null operator in sql?
What is a temporal data type?
Differentiate between sga and pga.
What is sql and its types?
Explain how can you save or place your msg in a table?
What is the difference between a subquery and a join?
What is sqlerrd?
How do I view a sql trace file?