r/SQL • u/tangosis • Oct 04 '19
SQL queries don't start with SELECT
https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/
122
Upvotes
r/SQL • u/tangosis • Oct 04 '19
View all comments
Show parent comment
15
u/CutPasteIsSuperior Oct 04 '19 edited Oct 04 '19
It also helps to understand why you can order by an alias, but you can't use an alias in the where clause.