The functions SUM, COUNT, AVG, MIN, MAX are the common analytic functions the result of which does not depend on the order of the records.
Functions like LEAD, LAG, RANK, DENSE_RANK, ROW_NUMBER, FIRST, FIRST VALUE, LAST, LAST VALUE depends on order of records.
Analytical functions are mainly used for analysis of data.The analytical function we may use order by clause and partition by clause.
1.LEAD
2.LAG
3.RANK,
4.DENSE_RANK
5.ROW_NUMBER
6.FIRST
7.FIRST VALUE
8.LAST
9.LAST VALUE
Functions like LEAD, LAG, RANK, DENSE_RANK, ROW_NUMBER, FIRST, FIRST VALUE, LAST, LAST VALUE depends on order of records.
Analytical functions are mainly used for analysis of data.The analytical function we may use order by clause and partition by clause.
1.LEAD
2.LAG
3.RANK,
4.DENSE_RANK
5.ROW_NUMBER
6.FIRST
7.FIRST VALUE
8.LAST
9.LAST VALUE
No comments:
Post a Comment