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

What are the Common SQL Functions Used for Data Aggregation?

Answer Posted / hr@tgksolutions.com

SUM(): Determines a numeric column's total sum.
AVG(): Determines a numeric column's average value.
COUNT(): Determines how many rows satisfy a certain criterion.
MIN(): Determines a column's lowest value.
MAX(): Determines a column's maximum value.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between primary key and secondary key?

923


What database does facebook use?

905


What is cardinality in db?

944


What are the different stages in 'data warehousing'?

920


What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?

825


What is meant by database system?

858


What do you understand by cursor?

887


Explain the Logical Schema of Database

954


how Data is stored in a file so that Direct Searching can be performed

962


What do you understand by functional dependency?

866


Explain the difference between two and three-tier architectures.

870


What are fact tables and dimension tables ? What is dimensional modeling and star schema design

826


What are the 3 types of relationships in a database?

847


Why is the use of dbms recommended? Explain by listing some of its major advantages.

1628


State at least four kinds of indexing?

965