Operator Precedence : Query Select « Query « SQL Server / T-SQL Tutorial

Precedence      Operator(s)
1               0(parentheses)
2               + (Positive), - (Negative), ~ (Bitwise NOT)
3               * (Multiply), / (Divide), % (Modulo)
4               + (Add), (+ Concatenate), - (Subtract)
5               =, >, <, >=, <=, <>, !=, !>, !< (Comparison operators)
6               ^ (Bitwise XOR), & (Bitwise AND), | (Bitwise OR)
7               NOT
8               AND
9               ALL, ANY, BETWEEN, IN, LIKE, OR, SOME
10              = (Assignment)

1.1.Query Select
	1.1.1.	The basic syntax of the SELECT statement
	1.1.2.	The operators you can use in a search condition
	1.1.3.	Both uppercase and lowercase statements are acceptable, a query could be written as follows:
	1.1.4.	Operator Precedence
	1.1.5.	asterisk (*) specifies all columns of the named tables in the FROM clause
	1.1.6.	A SELECT statement that retrieves rows with non-zero values
	1.1.7.	A SELECT statement that retrieves two columns and a calculated value for a specific Billing
	1.1.8.	retrieve specific columns
	1.1.9.	A SELECT statement that retrieves three columns from each row, sorted in descending sequence by Billing total
	1.1.10.	A SELECT statement that returns an empty result set
	1.1.11.	SELECT 1.0 + 3.0 / 4.0 -- Returns 1.75
	1.1.12.	SELECT (1.0 + 3.0) / 4.0 -- Returns 1.00
	1.1.13.	The specification column_name [as] column_heading
	1.1.14.	Table alias
	1.1.15.	add a WHERE clause and group by
	1.1.16.	A SELECT statement that uses the CHAR function to format output
	1.1.17.	Use local variable in a select statement
	1.1.18.	Using SELECT to Create a Script