Jared Still’s Corner

OSWOUG recognizes the exemplary contributions made to our User Group.  This is a small accumulation of Jared’s work and is not directly posted by him.

 

SQL Grouping Code Examples

Visit Slides Library : “Optimize SQL with Advanced Grouping” 

Presentor:  Jared Still

Presentation Date:  August 14, 2012

The Standard Insurance Center

gb_1.sqlJareds_Corner_files/gb_1.sqlJareds_Corner_files/gb_1_1.sqlshapeimage_1_link_0

gb_1a.sql

gb_1b.sql

gb_2.sql

gb_3.sql

gb_4.sql

gb_5.sql

gb_6.sql

gb_7.sql

gb_8.sql

gb_9.sql

gb_10a.sql

gb_10b.sql

gb_11.sql

gb_12a.sql

gb_12b.sql

gb_13.sql

gb_14a.sql

gb_14b.sql

gb_14c.sql

gb_15a.sql

gb_15b.sql

gb_16.sql

flush.sql

gl_cube.sql

gl_group_id.sql

gl_grouping_id.sql

gl_grouping_sets.sql

gl_rollup.sql

group_by_malformed.sql

gs.sql

setup.sql

showplan_last.sql

sqlprompt.sql