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
- 16240 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
how to shutdown mysql server? : Sql dba
what is data control language? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba
How many aggregate functions are available there in sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
how many tables will create when we create table, what are they? : Sql dba
What are the various restrictions imposed on view in terms of dml?
How to change sql*plus system settings?
How do I view a procedure in sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
Explain locks? : Transact sql
What are different types of sql commands?
What is orm in sql?
How do you create an update query?
What is function and procedure?
