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

Difference between aggregate function and analytical function?

Answer Posted / pradeep

aggregate function - it returns only single value and (aggr Fun are Min,Max,Count,Sum,Avg)
analytical Function - it returns more than one value and (Analy fun are, string,date, numeric,conversions, and miscellaneous)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why commit is not used in triggers?

1084


what are the differences between char and varchar? : Sql dba

1111


Can there be more than one function with a similar name in a pl/sql block?

1036


Whis is not false in primary key?

1515


Why we use joins in sql?

1033


what is the difference between delete and truncate commands? : Sql dba

1110


Is sql scripting language?

1108


Differentiate between sga and pga.

1204


Is big data nosql?

995


Can delete statement be rollbacked?

1029


How can we implement rollback or commit statement in a trigger?

1079


Enlist the data types that can be used in pl/sql?

1106


Is sql injection illegal?

1076


How do I save a stored procedure?

1064


What is information schema in sql?

1112