T-SQL Tutorials - TSQLTutorials.com
The SELECT statement is used for retrieving data from a table. This SQL Statement begins with the keyword SELECT. The results from the SELECT query is called the 'Resultset'. The SELECT Statement has two basic parts:
following the 'FROM' keyword will be the table to be selected from.
This example will select the 'Name', 'Position' and 'Salary' columns' content from the 'Employees' table. Note: This example selects all of the records from the table.
SELECT Name, Position, Salary
Selecting ALL Columns - *
Previously we selected columns by specifying the column names. By using the * symbol, we can select all the columns from a table
Limiting Rows - WHERE clause
The WHERE clause acts as a filter on the resultset. By adding a WHERE clause after the FROM keyword, the resultset can be limited to rows that meet particular conditions.
This example will select the 'Name', 'Position' and 'Salary' columns' content from the 'Employees' table, where the employee's Salary is greater than 61,000. SELECT Name, Position, Salary
WHERE Salary > 61000 Here is a sample resultset from the above SELECT query: