T-SQL Tutorials - TSQLTutorials.com

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
following the 'SELECT' keyword will be the columns to be selected
following the 'FROM' keyword will be the table to be selected 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:

NamePositionSalary
Joe GrapeManager80000
John PlumSoftware Developer65000
Frank AppleSoftware Developer62000
Patty PineappleSoftware Developer60000
Judy PeachSoftware Developer50000
Jane OrangeProject Manager75000




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:

NamePositionOfficeSalary
Joe GrapeManagerHouston80000
John PlumSoftware DeveloperHouston65000
Frank AppleSoftware DeveloperCleveland62000
Patty PineappleSoftware DeveloperCleveland60000
Judy PeachSoftware DeveloperBoston50000
Jane OrangeProject ManagerHouston75000

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:

NamePositionSalary
Joe GrapeManager80000


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
FROM Employees
WHERE Salary > 61000
Here is a sample resultset from the above SELECT query:
NamePositionSalary
Joe GrapeManager80000
John PlumSoftware Developer65000
Frank AppleSoftware Developer62000
Jane OrangeProject Manager75000


Microsoft SQL Server 2014 Standard Edition Server w/20 CAL’s

Price: $641.99
Buy It Now
Microsoft SQL Server 2008 R2 Standard Server License key +5CAL FactorySealedPack

Price: $495
Buy It Now
Microsoft SQL Server 2012 Standard 10CAL +Server License Key Factory Sealed Pack

Price: $899
Buy It Now
Microsoft SQL Server 2012 Standard with SP3 - 25 CAL License - SAME DAY DOWNLOAD

Price: $700
Buy It Now
Lenovo Microsoft SQL Server 2014 - License - 1 User CAL - OEM

Price: $169.99
Buy It Now
Microsoft SQL Server Standard 2014 + 10 Cal

Current Price: $122.5
Current Bids: 8







Copyright 2017 - TSQLTutorials.com