KO | EN

GitLite

Minimalist Open Source Repository Search Engine

gitlite — search

#dsh #ai-agents #dsh-plugin #codex #developer-tools #claude-code #windows #cli #desktop-app #typescript #rust #ai-agent

sql-snippets

★ 211 Open GitHub ↗

A curated collection of helpful SQL queries and functions, maintained by Count.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# SQL Snippets
 
A curated collection of helpful SQL queries and functions, maintained by [Count](https://count.co).

All [contributions](./CONTRIBUTING.md) are very welcome - let's get useful SQL snippets out of Slack channels and Notion pages, and collect them as a community resource.

### [🙋‍♀️ Request a snippet](https://github.com/count/sql-snippets/issues/new?assignees=&labels=help+wanted&template=snippet-request.md&title=%5BSNIPPET+REQUEST%5D+)
### [⁉️ Report a bug](https://github.com/count/sql-snippets/issues/new?assignees=&labels=bug&template=bug_report.md&title=%5BBUG%5D+)
### [↣ Submit a pull request](https://github.com/count/sql-snippets/compare)

<!--
Database badges

The colour of the badge is taken from the dominant colour of the database logo.

![BigQuery](https://img.shields.io/badge/BigQuery-4387FB)
![MySQL](https://img.shields.io/badge/MySQL-F29111)
![Postgres](https://img.shields.io/badge/Postgres-336791)
![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)
![SQL Server](https://img.shields.io/badge/SQL%20Server-A91D22)
-->

| Snippet | Databases |
| ------- | --------- |
| <h3>Analytics</h3> | |
| Cohort analysis |  [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/cohort-analysis.md) |
| Cumulative distribution functions | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/cdf.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/cume_dist.md) [![MySQL](https://img.shields.io/badge/MySQL-F29111)](https://raw.githubusercontent.com/count/sql-snippets/main/mysql/cdf.md) ![SQL Server](https://img.shields.io/badge/SQL%20Server-A91D22)|
| Compound growth rates | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/compound-growth-rates.md) [![SQL Server](https://img.shields.io/badge/SQL%20Server-A91D22)](https://raw.githubusercontent.com/count/sql-snippets/main/mssql/compound-growth-rates.md) |
| Generate a binomial distribution | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/binomial-distribution.md) |
| Generate a uniform distribution | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/uniform-distribution.md) |
| Histogram bins | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/histogram-bins.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/histogram-bins.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/histogram-bins.md) |
| Median | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/median.md) |
| Median (UDF) | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/median-udf.md) |
| Outlier detection: MAD method | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/outliers-mad.md) |
| Outlier detection: Standard Deviation method | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/outliers-stdev.md) |
| Outlier detection: Z-score method | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/outliers-z.md) |
| Random Between | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/rand_between.md) |
| Random sampling | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/random-sampling.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/random-sampling.md) |
| Ranking | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/rank.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/rank.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/rank.md) |
| TF-IDF | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/tf-idf.md) |
| <h3>Arrays</h3>| |
| Arrays to columns | [![BigQuery](https://img.shields.io/badge/BigQuery-4387FB)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/array-to-columns.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/flatten-array.md) | |
| Filtering arrays | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/filtering-arrays.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/filtering-arrays.md) |
| Generating arrays | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/generating-arrays.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/generate-arrays.md) |
| Get last array element | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/get-last-array-element.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/get-last-array-element.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/last-array-element.md) |
| Reverse array | [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/array-reverse.md) |
| Transforming arrays | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/transforming-arrays.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/transforming-arrays.md) |
| Least non-null value in array (UDF) |  [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/least-udf.md) |
| Greatest/Least value in array |  [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/least-array.md) |
| Sort Array (UDF) |  [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/udf-sort-array.md) |
| <h3>Charts</h3>| |
| Bar chart | [![BigQuery](https://img.shields.io/badge/BigQuery-4387FB)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/bar-chart.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/bar-chart.md) |
| Horizontal bar chart | [![BigQuery](https://img.shields.io/badge/BigQuery-4387FB)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/horizontal-bar.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/horizontal-bar.md) |
| Time series | [![BigQuery](https://img.shields.io/badge/BigQuery-4387FB)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/timeseries.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/timeseries.md) |
| 100% stacked bar chart | [![BigQuery](https://img.shields.io/badge/BigQuery-4387FB)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/100-stacked-bar.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/100-stacked-bar.md) |
| Heat map | [![BigQuery](https://img.shields.io/badge/BigQuery-4387FB)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/heatmap.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/heatmap.md)  |
| Stacked bar and line chart | [![BigQuery](https://img.shields.io/badge/BigQuery-4387FB)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/stacked-bar-line.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/stacked-bar-line.md)  |
| <h3>Database metadata</h3>| |
| Check if column exists in table | [![SQL Server](https://img.shields.io/badge/SQL%20Server-A91D22)](https://raw.githubusercontent.com/count/sql-snippets/main/mssql/check-column-is-accessible.md) |
| Search for text in Stored Procedures | [![SQL Server](https://img.shields.io/badge/SQL%20Server-A91D22)](https://raw.githubusercontent.com/count/sql-snippets/main/mssql/search-stored-procedures.md) |
| <h3>Dates and times</h3>| |
| Date/Time Formatting One Pager|  [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/dt-formatting.md) |
| Converting from strings | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/convert-string-datetimes.md) |
| Converting to strings | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/convert-datetimes-string.md) |
| Local Timezone to UTC | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/localtz-to-utc.md) |
| Converting epoch/unix to timestamp | [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/convert-epoch-to-timestamp.md) |
| Generate timeseries | [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/generate-timeseries.md) |
| Last day of the month | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/last-day.md) |
| Last X days |  [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/last-x-days.md) |
| <h3>Geography</h3>| |
| Calculating the distance between two points | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/geographical-distance.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/geographical-distance.md) |
| <h3>JSON</h3>| |
| Parsing JSON strings | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/json-strings.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/json-strings.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/parse-json.md)|
| <h3>Regular & String expressions</h3>| |
| Parsing URLs | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/regex-parse-url.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/parse-url.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/regex-parse-url.md) |
| Validating emails | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/regex-email.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/regex-email.md) |
| Extract repeating words |  [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/repeating-words.md) |
| Split on Uppercase characters | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/split-uppercase.md) |
| Replace multple conditions | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/replace-multiples.md) |
| CONCAT with NULLs |  [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/concat-nulls.md) |
| Capitalize initial letters (UDF) |  [![MySQL](https://img.shields.io/badge/MySQL-F29111)](https://raw.githubusercontent.com/count/sql-snippets/main/mysql/initcap-udf.md) |
| Concatenating strings | [![SQL Server](https://img.shields.io/badge/SQL%20Server-A91D22)](https://raw.githubusercontent.com/count/sql-snippets/main/mssql/concatenate-strings.md) |
| <h3>Transformation</h3>| |
| Pivot | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/pivot.md)  [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/pivot.md) |
| Unpivoting / melting | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/unpivot-melt.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/unpivot-melt.md) | 
| Replace NULLs | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/replace-null.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/replace-null.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/replace-null.md) |
| Replace empty string with NULL | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/replace-empty-strings-null.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/replace-empty-strings-null.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/replace-empty-strings-null.md) |
| Counting NULLs | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/count-nulls.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/count-nulls.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/count-nulls.md) |
| Splitting single columns into rows | [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/split-column-to-rows.md) |
| Latest Row (deduplicate) | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/latest-row.md) |
| <h3>Window functions</h3>| |
| First row of each group | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/first-row-of-group.md) [![SQL Server](https://img.shields.io/badge/SQL%20Server-A91D22)](https://raw.githubusercontent.com/count/sql-snippets/main/mssql/first-row-of-group.md) |
| Moving averages | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/moving-average.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/moving-average.md) [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/moving-average.md) |
| Running totals | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/running-total.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/running-total.md) |
| Year-on-year changes | [![BigQuery](https://img.shields.io/badge/BigQuery-4387fb)](https://raw.githubusercontent.com/count/sql-snippets/main/bigquery/yoy.md) [![Snowflake](https://img.shields.io/badge/Snowflake-29B5E8)](https://raw.githubusercontent.com/count/sql-snippets/main/snowflake/yoy.md) |
| Creating equal-sized buckets | [![Postgres](https://img.shields.io/badge/Postgres-336791)](https://raw.githubusercontent.com/count/sql-snippets/main/postgres/ntile.md) |

## Other resources
- [bigquery-utils](https://github.com/GoogleCloudPlatform/bigquery-utils) - a BigQuery-specific collection of scripts

sql-snippets

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README