SQL Cheat Sheet (Oracle, SQL Server, MySQL, PostgreSQL) https://www.databasestar.com/sql-cheat-sheets/ Advanced T-SQL OVER PARTITION - it's like GROUP BY but within a SELECT clause.