O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 31

Partitioning and Aggregating Data in Queries

Abstract

This section is concerned with how to break the data in SQL into meaningful subsets that can then be presented to the user or passed along for further reduction. This is not the same as physical partitioning which moves data to slower storage administrative reasons.

Keywords

Subsets

Partition

Covering

Ranges

Soundex function

NTILE()

This chapter is concerned with how to break the data in SQL into meaningful subsets that can then be presented to the user or passed along for further reduction.

31.1 Coverings and Partitions

We need to define some basic set operations. A covering is a collection of subsets, drawn from a set, whose union is the original set. A partition is a covering ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required