sqlcmd.net validated sql reference

Tag archive

#gaps-and-islands

Commands grouped around the same concept, pattern, or recurring problem.

1 commands with this tag Browse related patterns quickly
advanced windowing MySQL MariaDB SQL Server PostgreSQL SQLite

Group Consecutive Rows With A ROW_NUMBER Difference

Create stable run groups without a primary key by subtracting two `ROW_NUMBER()` calculations over the same ordered events.