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

How does postgresql compare to "nosql"?

980


What is set transaction?

987


how can you create an empty table from an existing table? : Sql dba

1076


what is a composite primary key ? : Sql dba

996


What are the advantages of sql?

1005


What is a sql trace file?

973


If a cursor is open, how can we find in a pl/sql block?

1103


Does postgresql run on the cloud?

1073


how would concatenate strings in mysql? : Sql dba

1011


What is a string data type in sql?

956


What is composite data type in pl sql?

1030


How to load data with sql*loader?

994


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1091


Does sql*plus have a pl/sql engine?

994


Is sql easier than java?

944