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
- 14154 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / sanjeev
You can use COUNT(field),MIN(field),MAX(field) functions for
character fields.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between unique and primary key constraints?
Why does sql need a server?
What is the use of nvl function?
Why is pl sql used?
What does inner join mean?
Does a primary key have to be a number?
What view means?
What are the types of keys?
What are the types of functions in sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Can one improve the performance of sql*loader? : aql loader
Can you join views in sql?
What do you mean by stored procedures? How do we use it?
What is the most common sql injection tool?
