SQL SELECT Statement
How do I get data from a database?
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 frequently used action on a database.
The SQL SELECT syntax
The general syntax is
SELECT column-names FROM table-name
To select all columns use *
SELECT * FROM table-name
CUSTOMER |
---|
Id |
FirstName |
LastName |
City |
Country |
Phone |
SQL SELECT Examples
Problem: List all customers
SELECT * FROM Customer
Result: 91 records
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 |
![]() |
CUSTOMER |
---|
Id |
FirstName |
LastName |
City |
Country |
Phone |
Problem: List the first name, last name, and city of all customers
SELECT FirstName, LastName, City FROM Customer
Result: 91 records
FirstName | LastName | City |
---|---|---|
Maria | Anders | Berlin |
Ana | Trujillo | México D.F. |
Antonio | Moreno | México D.F. |
Thomas | Hardy | London |
Christina | Berglund | Luleå |
![]() |