Chapters

SQL Language

Posted by: Jaspreet

Last Updated on: 09 Oct, 2021


Basic Querying

Chapters

Table of Contents

1) Basics
2) Intermediate
3) Window Functions

1) Basics

SELECT and WHERE:

Aggregrators: COUNT, SUM, MAX, GROUP BY, HAVING

DISTINCT, COUNT DISTINCT:

Joins:

Self Joins:

UNION and UNION ALL:

2) Intermediate

CASE WHEN:

Handling NULLs creatively: COALESCE

Subqueries:

Window functions: PARTITION, LEAD, LAG, NTILE

UDFs:

Recursive CTEs: