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)
Answer Posted / santhosh , hyd
COUNT(field) and MAX(field)
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What normalization means?
What will you get by the cursor attribute sql%rowcount?
How are sql commands classified?
Write the command to remove all players named sachin from the players table.
How do I run sql profiler?
How do I debug a stored procedure?
What is a Mapplet?
What is a constraint?
what are date and time functions in mysql? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is difference between pls_integer and integer?
What are sql constraints?
what is a materialized view? : Sql dba