SQL – Basic SQL on one table

SQL BASICs Order of SQL Operations FROM –> table selectopn WHERE –> row(s) selection GROUP BY –> rows grouping by column Aggregations on columns –> in SELECT  or ORDER BY HAVING –> in case you have to select on an aggregated value WINDOW functions –> operations on a selection of rows SELECT –> column selection […]