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
- 16598 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 type of database is cloud sql?
What is t-sql? : Transact sql
What is the use of stored procedures?
Can a foreign key have a different name?
how to fetch alternate records from a table? : Sql dba
What are all the different normalization?
How delete a row in sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is a temp table?
What is cold data?
What is a boolean in sql?
What is $$ in sql?
Define concurrency control. : Transact sql
What does := mean in pl sql?
What is user in sql?
