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)
Answers were Sorted based on User's Feedback
Answer / tulsi
1)THE COUNT(field) and MAX(field) CAN BE USED WITH
CHARACTER FIELDS
Is This Answer Correct ? | 14 Yes | 1 No |
Answer / guru manohar
You can use COUNT(field),MIN(field),MAX(field) functions for
character fields.
For example there is a table called DEPARTMENTS contains the
data as shown below:
DEPARTMENT_ID DEPARTMENT_NAME
---------------------------------
10 Administrator
20 Marketing
50 Shipping
60 IT
1)SELECT COUNT(department_name)
From DEPARTMENTS;
Output: 4
Note: Bcoz there are 4 rows with DEPARTMENT_NAME
2)SELECT MAX(department_name)
From DEPARTMENTS;
Output: Shipping
Note: Bcoz Shipping comes last in sorting by Ascending
3)SELECT MIN(department_name)
From DEPARTMENTS;
Output: Administrator
Note: Bcoz Administrator comes first in sorting by Ascending
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sanjeev
You can use COUNT(field),MIN(field),MAX(field) functions for
character fields.
Is This Answer Correct ? | 3 Yes | 0 No |
What is foreign key and example?
What is mdb stand for?
What is a pragma statement?
What is not in sql?
what is the syntax used for partition in tsql? : Transact sql
What is Highwatermark?
25.67,-1 Trunc = 20 Round= 30 HOW????
What is meant by <> in sql?
how to create object in plsql
what is recursive stored procedure? : Sql dba
sql query to get zero records from a table having n no of records
what is difference between procedure and function
10 Answers MCN Solutions, Wipro,