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
- 14151 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / santhosh , hyd
COUNT(field) and MAX(field)
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is coalesce in sql?
Name the operator which is used in the query for pattern matching?
Can we use pl sql in sql server?
What is count * in sql?
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 is offset in sql query?
What is a Mapplet?
Which sql most popular?
How many sql statements are used? Define them.
Explain the difference in execution of triggers and stored procedures?
Why is nosql good?
Explain spool.
Can we insert in sql function?
Explain the difference between triggers and constraints?
What is difference between sql and excel?
