Search

Top 60 Oracle Blogs

Recent comments

SQL Server

You've Got Framing

The framing clause brings the "window" to window functions. It's an ideal
solution when you can arrange a business question such that an answer comes
from applying an aggregate function to a range...



Read the full post at www.gennick.com/database.

You've Got Framing

The framing clause brings the "window" to window functions. It's an ideal
solution when you can arrange a business question such that an answer comes
from applying an aggregate function to a range...



Read the full post at www.gennick.com/database.

Pulling Rank for the Boss

Look to ROW_NUMBER, RANK, and DENSE_RANK anytime you are faced with a
business question involving words or phrases such as "topmost" or
"bottommost", "top N" or "bottom N", or that is otherwise...



Read the full post at www.gennick.com/database.

Pulling Rank for the Boss

Look to ROW_NUMBER, RANK, and DENSE_RANK anytime you are faced with a
business question involving words or phrases such as "topmost" or
"bottommost", "top N" or "bottom N", or that is otherwise...



Read the full post at www.gennick.com/database.

Interlude

Having the right mental model of how window functions operate goes a long
way toward recognizing when and how to apply these functions that can seem
almost magical in the expressive power.



Read the full post at www.gennick.com/database.

Interlude

Having the right mental model of how window functions operate goes a long
way toward recognizing when and how to apply these functions that can seem
almost magical in the expressive power.



Read the full post at www.gennick.com/database.

H. G. Wells and SQL: Traveling in the Second Dimension

SQL is traditionally one-dimensional in that you can access values in a
row, in the horizontal dimension. SQL Server 2012's support of LAG and LEAD
and other so-called window functions open up the...



Read the full post at www.gennick.com/database.

H. G. Wells and SQL: Traveling in the Second Dimension

SQL is traditionally one-dimensional in that you can access values in a
row, in the horizontal dimension. SQL Server 2012's support of LAG and LEAD
and other so-called window functions open up the...



Read the full post at www.gennick.com/database.

Detail in the Aggregate

SQL Server 2012 – the "Denali" release – brings improved support for window
functions as defined in the SQL standard. One of the things you can now do
is to mix summary and detail results in the...



Read the full post at www.gennick.com/database.

Detail in the Aggregate

SQL Server 2012 – the "Denali" release – brings improved support for window
functions as defined in the SQL standard. One of the things you can now do
is to mix summary and detail results in the...



Read the full post at www.gennick.com/database.