Skip to main content
snippets
S
nippets
SQL
Snippets
Date
•
Title
Get Table Schema
SQL
10 years ago
database
mssql
schema
sql
table
SQL Server Details
SQL
10 years ago
mssql
query
server
sql
windows
Pinboard database schema
SQL
11 years ago
database
examples
mysql
pinboard
schema
MySQL delete dupes on multiple columns
SQL
11 years ago
dupe
mysql
MySQL delete dupes, keep newer
SQL
11 years ago
dupe
mysql
Create MySQL table template
SQL
12 years ago
mysql
table
template
Replace text in all string columns of a database
SQL
12 years ago
mysql
replace
text
Monthly sales in MySQL
SQL
12 years ago
mysql
pivot
query
report
Great circle distance in MySQL
SQL
12 years ago
circle
distance
formula
mysql
Percentiles in MySQL
SQL
12 years ago
algorithm
mysql
percentile
statistics
Winning Streaks in MySQL
SQL
12 years ago
algorithm
mysql
query
Gaps in a time series in MySQL
SQL
12 years ago
analysis
datetime
mysql
query
Aggregates excluding leaders in MySQL
SQL
12 years ago
aggregate
mysql
rank
All X for which all Y are Z MySQL query
SQL
12 years ago
aggregate
mysql
query
Aggregates of specified size
SQL
12 years ago
aggregate
group
mysql
query
Avoiding repeat aggregation in MySQL
SQL
12 years ago
aggregate
mysql
query
Combine Group_Concat() with counts in MySQL
SQL
12 years ago
group
mysql
query
Nested aggregation in MySQL
SQL
12 years ago
aggregate
algorithm
mysql
League table in MySQL
SQL
12 years ago
examples
mysql
table
Group data by datetime periods in MySQL
SQL
12 years ago
datetime
mysql
query
First
«
6
7
8
9
10
11
12
13
»
More »