Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16005 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is sql server and ase?
Why is sql important?
Why stored procedure is better than query?
What is mutating table error?
What is the use of sqlerrd 3?
Can we commit inside a trigger?
How to pipe multiline string to isql?
Can we join 3 tables in sql?
What is acid property in a database?
Can we use view in stored procedure?
What is query optimization in sql?
What is the sql*loader? : aql loader
What is the trigger in sql?
what is schema? : Sql dba
How do I restart sql?
