Chapters

SQL Language

Posted by: Juspreet51

Last Updated on: 09 Oct, 2021


Basic Querying


Chapters




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: