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
- 15006 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 are the differences between char and nchar? : Sql dba
What is a parameter query?
What is coalesce in sql?
Why self join is used in sql?
what is query cache in mysql? : Sql dba
Explain normalization and what are the advantages of it?
What has stored procedures in sql?
What is input buffer in sql*plus?
What is left inner join in sql?
What do you mean by dbms? What are its different types?
What is pl sql and why it is used for?
Should I use mbr or gpt?
What is the use of non clustered index?
i have some prob lem to tell me about my self in interview first round ...
What are the different schemas objects that can be created using pl/sql?
