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

How do I count records in sql?

0 Answers  

what are date and time intervals? : Sql dba

0 Answers  

What is scalar function in sql?

0 Answers  

What is trigger types of trigger?

0 Answers  

What is synonyms?

0 Answers  

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  

Does a primary key have to be a number?

0 Answers  

What is the largest value that can be stored in a byte data field?

0 Answers  

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

What is meant by truncate in sql?

0 Answers  

What is difference between sql function and stored procedure?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories