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


Please Help Members By Posting Answers For Below Questions

What is pl sql record in oracle?

563


What is a composite primary key?

581


how to shut down the server with 'mysqladmin'? : Sql dba

543


Explain the types of joins in sql?

571


How does rowid help in running a query faster?

965






What do you mean by dbms? What are its different types?

552


What schema means?

523


How do I copy a table in sql?

515


What is dense_rank in sql?

539


how to increment dates by 1 in mysql? : Sql dba

539


What is a column in a table?

548


Why left join is used in sql?

516


How do you declare a constant?

524


What is optimistic concurrency control? : Transact sql

544


Is sql a backend language?

618