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 |
What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Why we use pl sql?
What is a left inner join?
Explain the two type of Cursors ?
how to retrieve only duplicate values in a table
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How do rank () and dense_rank () differ?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
Can %notfound return null after a fetch?
What language is oracle sql developer?
When is the explicit cursor used ?