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)
Answers were Sorted based on User's Feedback
Answer / tulsi
1)THE COUNT(field) and MAX(field) CAN BE USED WITH
CHARACTER FIELDS
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / 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 |
Answer / sanjeev
You can use COUNT(field),MIN(field),MAX(field) functions for
character fields.
| Is This Answer Correct ? | 3 Yes | 0 No |
why we go for package? what are the advantages of using instead of seperate procuderes or functions
What are wait events. Describe the wait event tables.
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
How do I make sql search faster?
How do I copy a table in sql?
What is the difference between left join and left outer join?
What is structural independence and why is it important?
What is data type in database?
What is the use of triggers?
What is the purpose of using pl/sql?
What is a design view?
When would you denormalize?
8 Answers MBT, Microsoft, MMU,
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)