Query Select « Query « SQL Server / T-SQL Tutorial

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