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
- 16337 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 sql functions? Describe the different types of sql functions?
what is 'mysqlcheck'? : Sql dba
what is try_catch block in procedure
What is difference between stored procedures and application procedures?
What is the difference between partition and index?
Should I use mbr or gpt?
Enlist the characteristics of pl/sql?
What information is needed to connect sql*plus an oracle server?
How do you write an inner join query?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is raw datatype in sql?
Explain ttitle and btitle.
How do you write a subquery?
What is sqlerrm?
What view means?
