quick-SQL-cheatsheet
quick-SQL-cheatsheet copied to clipboard
A quick reminder of all SQL queries and examples on how to use them.
I am wondering why "Creating Table Query" is 7th not the 1st? Thanks.
Added update statement for updating from multiple tables
Added create procedure, call procedure and drop a procedure. Added create a trigger, show all triggers and drop a trigger.
Not specifically a query, but still very useful
Improves SQL cheatsheet with new sections: - Advanced functions (CASE, COALESCE, STRING_AGG) - Common patterns for queries (paging, find duplicates, conditional aggregation)