Difference between aggregate function and analytical function?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How do I remove duplicates in two columns?
How to display all Friday's in a year with date?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What do you mean by dbms? What are its different types?
Explain the rollback statement?
How do I view a sql trace file?
Is sql a case sensitive language?
What is bind variable in pl sql?
Can we call a function containing dml statements in a select query?
What is the difference between rename and alias?
How do I find sql profiler?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba