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

Aggregate Function : Which returns one row for a group.

Analytical Function : which returns one result for each row in the group.


feedback accepted.

Is This Answer Correct ?    60 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between drop and truncate commands?

996


What is a dynamic query?

969


What are the three pl sql block types?

945


How much does sqlite cost?

982


How to use sql*plus built-in timers?

1094


What is the difference between Union and Union all. Which is faster.

1340


Can procedure in package be overloaded?

1028


What is sql server and ase?

972


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

924


How to return multiple rows from the stored procedure?

912


Can we group by two columns in sql?

942


what is the command line end user interface - mysql? : Sql dba

925


explain access control lists. : Sql dba

946


What are sql functions? Describe in brief different types of sql functions?

1009


How can you select unique records from a table?

987