SQL patterns at a glance.

Search the syntax used throughout the WorkTools learning path.

Pattern	Use it for	Example
SELECT	Return chosen columns	`SELECT OrderID, Status FROM Orders;`
WHERE	Filter source rows	`WHERE Status = 'Open'`
LIKE	Pattern match	`WHERE Code LIKE 'PO-%'`
IN	Match a list	`WHERE Status IN ('Open','Hold')`
BETWEEN	Match a range	`WHERE Qty BETWEEN 10 AND 50`
ORDER BY	Sort results	`ORDER BY Price DESC`
COUNT	Count rows	`COUNT(*)`
SUM	Total numeric values	`SUM(Quantity)`
AVG	Average numeric values	`AVG(LeadTime)`
GROUP BY	Aggregate per group	`GROUP BY Supplier`
HAVING	Filter groups	`HAVING COUNT(*) > 5`
INNER JOIN	Keep matching rows	`INNER JOIN B ON A.ID = B.ID`
LEFT JOIN	Keep all left rows	`LEFT JOIN B ON A.ID = B.ID`
CASE	Conditional output	`CASE WHEN Qty < 10 THEN 'LOW' ELSE 'OK' END`
WITH	Create a CTE	`WITH x AS (SELECT ...) SELECT * FROM x;`