Datasnips was built out of frustration in wasting time searching for Data Science & AI code snippets through old projects, documentation and internet sources.

We wanted a platform to easily find & organise our snippets, to share them with the community and discover those shared by other users.

At Datasnips you can quickly search, discover and bookmark snippets from the community, curate your own snippet library for easy reference and share your own snippets for others to use.

Our aim is for Datasnips to be the place where everyone can find the code snippet they need. Sign up to be part of the community.

Code Snippets Blog Login
  • Code Snippets
  • Blog
  • Login

SQL Snippets

Getting the Last Record Using Rank Function - T-SQL Example
SQL
Querying

#T-SQL

GregHe1979
2
Getting the Date for the Previous Saturday with T-SQL
SQL
Querying

#T-SQL

GregHe1979
2
Remove Leading Zeros from a Field with T-SQL
SQL
Querying

#T-SQL #Data Cleaning

GregHe1979
2
median
SQL
Querying

changjulian17
2
left join LATERAL
SQL
Querying

changjulian17
2
Join on Multiple Columns in SQL Query
SQL
Querying

#Joins #Multiple

analyseup
1
EXISTS
SQL
Querying

changjulian17
1
SQL RANK
SQL
Querying

changjulian17
1
SQL window function
SQL
Querying

changjulian17
1
SQL window function II: percent growth
SQL
Querying

changjulian17
1
SQL creating a view
SQL
Querying

changjulian17
1
SQL generate_series, dayofweek(DOW), weekday, functions
SQL
Querying

changjulian17
1
Top Contributors
detro
101
analyseup
100
GregHe1979
43
Find Snippets by Language
Python
R
SQL
Terminal
Find Snippets by Use
Data Preprocessing
Statistics & Probability
Visualisation & EDA
Data Preparation for Models
Supervised Learning
Computer Vision
By using Datasnips, you agree to our privacy policy including our cookie policy