SQL SELECT

SQL SELECT Statement

The SELECT statement retrieves data from a database.

The data is returned in a table-like structure called a result-set.

SELECT is the most commonly used operation in a database.

Problem: List all suppliers in Italy.

copy

copied to clipboard

SELECT *
  FROM Supplier
 WHERE Country = 'Italy'

SELECT *
  FROM Supplier
 WHERE Country = 'Italy'

SELECT syntax.

SELECT column-names
  FROM table-name

To include all columns use *

SELECT *
  FROM table-name

copy

copied to clipboard

SELECT * 
  FROM Customer

SELECT * 
  FROM Customer

Id	FirstName	LastName	City	Country	Phone
1	Maria	Anders	Berlin	Germany	030-0074321
2	Ana	Trujillo	México D.F.	Mexico	(5) 555-4729
3	Antonio	Moreno	México D.F.	Mexico	(5) 555-3932
4	Thomas	Hardy	London	UK	(171) 555-7788
5	Christina	Berglund	Luleå	Sweden	0921-12 34 65

copy

copied to clipboard

SELECT FirstName, LastName, City 
  FROM Customer

SELECT FirstName, LastName, City 
  FROM Customer

FirstName	LastName	City
Maria	Anders	Berlin
Ana	Trujillo	México D.F.
Antonio	Moreno	México D.F.
Thomas	Hardy	London
Christina	Berglund	Luleå

• Our Sql UPDATE Reference
• Our Sql INSERT Reference
• Our Sql DELETE Reference
• Our Sql SELECT TOP Reference