A Brief Review Of SQL SELECT
See full Playlist at • SQL Query Foundations
00:00 Introduction
00:37 Sample Data
01:23 SELECT * FROM...
02:28 Aggregates
02:55 Aggregates & NULL
03:21 ORDER BY
03:43 DISTINCT & ORDER BY
04:09 DISTINCT & TOP n
04:49 Rule for Select Distinct
05:58 Aggregates, Group By, Where, Having
06:45 WHERE vs HAVING
07:24 DISTINCT redundant with GROUP BY
08:05 Rule for SELECT & GROUP BY
08:35 Recap - 7 Takeaways
10:03 The End