Tag Archives: Analytical function

Convert the KEEP Clause in Dense_Rank\Rank Analytical from Oracle to PostgreSQL

Posted on October 19, 2019 by Deepak Mahto

Analytical functions are a powerful tool for extracting insights from data. PostgreSQL supports most of the analytical functionality of Oracle, but it does not have a KEEP clause. This article will show you how to convert the KEEP clause in … Continue reading →

Rate this:

Posted in AWS - Database, Oracle to, Oracle to PG migration | Tagged , , , , , , | Leave a comment

Distinct clause within Analytical function in PostgreSQL.

Posted on September 21, 2019 by Deepak Mahto

Migration from Oracle to PostgreSQL is interesting, in terms of challenges and use case it bring to deal with.Today will like to share what was reported by one of our colleagues while migrating application sql’s to PostgreSQL compliance. One of … Continue reading →

Rate this:

Posted in Oracle to, Oracle to PG migration, postgresql | Tagged , , , , , , | Leave a comment

Multiplication across rows and Analytical Functions.

Posted on December 6, 2016 by Deepak Mahto

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

Posted on August 18, 2016 by Deepak Mahto

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.

Posted on December 27, 2014 by Deepak Mahto

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