Category	Name	Description	Example
SELECT [distinct] <columns> FROM <tables> [<where_clause>] [group-by_clause] [<order-by_clause>]		SELECT * FROM table
SELECT count(*) FROM <tables> [<where_clause>]
SELECT [distinct] <columns> FROM <tables> [<where_clause>]
<SELECT_clause> union <select_clause> [<order-by_clause>]
SELECT expressions		DECLARE @miavar VARCHAR(255) SELECT @miavar = 'una piccola variabile stringa'
SELECT TOP num_rows columns FROM table