SELECT Statement

Introduction

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:

• SELECT
• FROM

Beginning Example

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
FROM Employees Here is a sample resultset from the above SELECT query:

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

In this example we will assume that the 'Employees' table contains the follow columns: 'Name', 'Position', 'Office' and 'Salary'. SELECT *
FROM Employees
Here is a sample resultset from the above SELECT query:

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 Position is 'Manager'. SELECT Name, Position, Salary
FROM Employees
WHERE Position = 'Manager' Here is a sample resultset from the above SELECT query:

Microsoft SQL Server Standard 2008 R2 10CAL 228-09180 Price: $2040 Buy It Now

SQL Server 2008 2005 Training Exam Test Developer DVD Enterprise Book mcts 5cal Current Price: $16.99 Current Bids: 0

★ NEW ★ MS SQL 2005 Server Standard with CAL ★ L@@K PRICE REDUCTION★ Price: $395 Buy It Now

Microsoft SQL Server 2008 - Enterprise with 25 CAL's Price: $13850 Buy It Now

228-04023 Microsoft SQL Server 2005 Standard 5 CAL Price: $1450 Buy It Now

Microsoft SQL Server 2005 Workgroup Edition 5 CAL, New Retail, PN A5K-01017 Price: $699.95 Buy It Now