Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 / 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


Please Help Members By Posting Answers For Below Questions

Which constraints we can use while creating database in sql?

1086


Can we rename a column in the output of sql query?

995


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963


What is the difference between microsoft access and sql?

1029


What is pl sql script?

1036


How do I create a memory optimized filegroup?

968


What is the difference between having and a where in sql?

1110


What is difference between procedure and trigger?

984


How to change the order of columns in Oracle SQL Plus ?

1058


Can a primary key be a foreign key?

1024


what is table? : Sql dba

1068


What is the purpose of normalization?

1047


What is cte?

986


What are commit, rollback, and savepoint?

999


How do you write an inner join query?

956