Tag Archives: Analytical function

Multiplication across rows and Analytical Functions.

Oracle or SQL Server provide Aggregation functions for MIN/MAX/COUNT/SUM, but suppose a scenario when we want multiplication of rows across a partition or complete table. Database does not provide any buildin function to achieve same. Suppose we have below expectations, … Continue reading

Rate this:

Posted in Helper SQL, Oracle Internal, SQL Server Learning | Tagged , , , , , | 1 Comment

Analytical Function at Rescue

With Analytical function in oracle, we can leverage very powerful data projections for complex data requirement. It exhibit great tool to play around group sets with in a window and achieve desired outcome. Will walk¬†¬†through one of requirement which application … Continue reading

Rate this:

Posted in Helper SQL | Tagged , , | 1 Comment

Analytical Function order of processing within SQL.

Personally Believe, Analytical functions in Oracle are Prime addition and provide great advantage in processing for required data projections. In current post will try to explain SQL order of processing for Analytical Functions. Most of us must be aware on … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , | 1 Comment