Anatomy of an SQL query: 7 steps - 9elements's deck

FROM generates the data set
WHERE filters the generated data set
GROUP BY aggregates the filtered data set
HAVING filters the aggregated data set
SELECT transforms the filtered, aggregated data set
ORDER BY sorts the transformed data set
LIMIT .. OFFSET frames the sorted data set

schnittchen

Last edit

2017-09-27

Jan Bussieck

Posted by schnittchen to 9elements's deck (2015-08-16 21:04)