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

What are types of exception?

922


differentiate between float and double. : Sql dba

1055


Can a foreign key be null?

1090


What is difference between hql and native sql?

1170


what is 'trigger' in sql? : Sql dba

1084


What are the ddl commands?

1010


how to see the create table statement of an existing table? : Sql dba

1012


How to write html code in pl sql?

1113


Does a primary key have to be a number?

963


Where is sql database stored?

979


Is left join faster than join?

1053


What is the need of merge statement?

1038


Explain unique key in sql.

1012


Does postgresql run on the cloud?

1144


What is plpgsql language?

1063