sqlcmd.net validated sql reference

Tag archive

#buckets

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

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

Bucket Rows Into Equal Groups With NTILE

Use `NTILE(n)` to divide an ordered result set into `n` roughly equal buckets and assign each row a bucket number.