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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Difference between aggregate function and analytical function?

Question Posted / sushma s

Answers were Sorted based on User's Feedback



Difference between aggregate function and analytical function?..

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

Difference between aggregate function and analytical function?..

Answer / yogish naik

we can observe that the aggregate functions return only one
row per group whereas analytic functions keeps all the rows
in the group. Using the aggregate functions, the select
clause contains only the columns specified in group by
clause and aggregate functions whereas in analytic functions
you can specify all the columns in the table.

The PARTITION BY clause is similar to GROUP By clause, it
specifies the window of rows that the analytic funciton
should operate on.

Is This Answer Correct ?    16 Yes 0 No

Difference between aggregate function and analytical function?..

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

More SQL PLSQL Interview Questions

What is row_number () in sql?

0 Answers  

What is oracle pl sql developer?

0 Answers  

discuss about myisam index statistics collection. : Sql dba

0 Answers  

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

how many tables will create when we create table, what are they? : Sql dba

0 Answers  

What is record variable?

0 Answers  

What kind of join is join?

0 Answers  

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

What are the various levels of constraints?

0 Answers  

What are different joins used in sql?

0 Answers  

How the execution will be done in exceptions?

2 Answers  

What is index example?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories