Oracle development topic: Analysis Function Summary

This article is about all the previous functions Article Summary:

I. Statistics:

Sum () Over ( [ Partition ]   [ Order ] )

Sum () Over ( [ Partition ]   [ Order ]
Rows Between Preceding And Following)

Sum () Over ( [ Partition ]   [ Order ]
Rows Between Preceding And   Current Row)

Sum () Over ( [ Partition ]   [ Order ]
Range Between Interval ' '   ' Day ' Preceding
And Interval ' '   ' Day ' Following)

For more information, see 《Oracle development topic: analysis functions (over)And 《Oracle development topic: window functions"

Ii. arrangement:

Rank () Over ( [ Partition ]   [ Order ]   [ Nulls first/last ] )

Dense_rank () Over ( [ Patition ]   [ Order ]   [ Nulls first/last ] )

Row_number () Over ( [ Partitionby ]   [ Order ]   [ Nulls first/last ] )

Ntile () Over ( [ Partition ]   [ Order ] )

For more information, see 《Oracle development topic: analysis function 2"

Iii. Maximum/minimum search:

Min () / Max () Keep (dense_rank first / Last [ Partition ]   [ Order ] )

For more information, see 《Oracle development topic: Analysis Function 3"

4. Search for the first or last record:

First_value / Last_value ( Sum () Over ( [ Patition ]   [ Order ]
Rows Between Preceding And Following ))

For more information, see 《Oracle development topic: window functions"

V. Comparison between adjacent records:

Lag ( Sum (), 1 ) Over ( [ Patition ]   [ Order ] )

For more information, see 《Oracle development topic: report functions"