Skip to content

Don-Data/SQL-Cheat-Sheet

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

57 Commits
0 data.sql
0 data.sql
 
 
1.1 SELECT.sql
1.1 SELECT.sql
 
 
1.2 ORDER BY.sql
1.2 ORDER BY.sql
 
 
1.3 ORDER BY DESC.sql
1.3 ORDER BY DESC.sql
 
 
1.4 TOP.sql
1.4 TOP.sql
 
 
1.5 DISTINCT.sql
1.5 DISTINCT.sql
 
 
1.6 CASE WHEN.sql
1.6 CASE WHEN.sql
 
 
2.1 WHERE.sql
2.1 WHERE.sql
 
 
2.2 BETWEEN.sql
2.2 BETWEEN.sql
 
 
2.3 LIKE.sql
2.3 LIKE.sql
 
 
2.4 IN.sql
2.4 IN.sql
 
 
2.5 IS NULL.sql
2.5 IS NULL.sql
 
 
3.1 SUM.sql
3.1 SUM.sql
 
 
3.2 Aggregates.sql
3.2 Aggregates.sql
 
 
4.1 GROUP BY.sql
4.1 GROUP BY.sql
 
 
4.2 HAVING.sql
4.2 HAVING.sql
 
 
5.1 INNER JOIN.sql
5.1 INNER JOIN.sql
 
 
5.2 LEFT JOIN.sql
5.2 LEFT JOIN.sql
 
 
5.3 RIGHT JOIN.sql
5.3 RIGHT JOIN.sql
 
 
5.4 FULL JOIN.sql
5.4 FULL JOIN.sql
 
 
5.5 Self Join.sql
5.5 Self Join.sql
 
 
5.6 Anti Join.sql
5.6 Anti Join.sql
 
 
5.7 CROSS JOIN.sql
5.7 CROSS JOIN.sql
 
 
README.md
README.md
 
 

Repository files navigation

SQL Query Cheat Sheet

This repo contains SQL queries for the Don Data SQL Query Cheat Sheet. The PDF version is available for free here.

Table of Contents

Description

This repository is a collection of SQL queries that show different aspects of the SQL Query Cheat Sheet.

How To Use

The data is created on the fly by appending the data.sql CTE before the individual queries. All other .sql files are intended to be individually appended after the "0 data.sql" query.

Author Info

About

Don Data

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published