Window Functions

Following is a series of articles on the expressiveness and problem-solving power of window and analytic functions in SQL. Examples and syntax are from SQL Server 2012, but most or all of what's said applies across the board to Oracle, DB2, PostgreSQL, and to any other database management system current in its support for SQL.

1. Detail in the Aggregate
2. H.G. Wells and SQL: Travelling in the Second Dimension
3. Interlude
4. Pulling Rank for the Boss
5. You've Got Framing!

Buy the set! Support the author.
Purchase your own copy of all five articles formatted as a Kindle eBook. Synchronize to any and all of your Kindle readers. Enjoy reading from anywhere, anytime.

Window Functions in SQL
Kindle Direct Publishing. January 2012.

SQL

An Incremental Approach to Developing SQL Queries
Analytic Magic
Creating Pivot Tables
Domains, Domains, My Kingdom for a Domain!
Finding Flight Legs
Is Yours a Union Shop?
Partition Outer-Joins
Regular Expression Anti-patterns
Returning the Days in a Month
Subquery Madness!
Which Table, Which Column?
Understanding the WITH Clause

Oracle Database

A Real-life Tuning Experience
External Tables and "Bad" Files
Extracting Synonyms
Getting Creative With SQL*Loader
How Do I Become a DBA?
Listing Tablespaces
Managing Database Objects in Groups
SQL*Loader: All-Null Lines
SQL*Plus Generates HTML
Lock the Door With Connection Manager
Does PL/SQL Implicitly Close Cursors? (follow-up #1 and #2)

Jonathan Gennick

Jonathan Gennick

Home

Database Articles

On Writing

Fun Stuff!

Random Articles

About Jonathan

Database Articles

Window Functions

SQL

Oracle Database