SQL Tutorial 7 : Summary & Cheatsheet

Here’s a cheatsheet to summarise the basic functions covered in this SQL Tutorial Series.   Function Syntax AND / OR SELECT column_name FROM table_name WHERE condition AND/OR condition IN SELECT column_name FROM table_name WHERE column_name IN (value1,value2,value3…...) GROUP BY SELECT column_name, aggregate_function(column_name) FROM table_name WHERE condition GROUP BY column_name HAVING SELECT column_name, aggregate_function(column_name) FROM table_name … Continue reading SQL Tutorial 7 : Summary & Cheatsheet