Tag Archives: Aggregate function

Aggregate Function , Distinct and NULL Values in Oracle.

While working on SQL Server with queries having aggregation got a warning message. “Warning: Null value is eliminated by an aggregate or other SET operation.” So thought let write up something on Aggregation and NULL Values for Tradition RDBMS for … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , | Leave a 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

Aggregate Function Nesting in Oracle.

It’s been a while, I published blog on Oracle. Today we will discuss on, nested aggregation functions and level it can be nested. Lets first understand what is nesting functions. Nested function is concept, when the output of one function … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , , , , | Leave a comment