you are at Encyclopedia of SQL >> SELECT
SELECT
In connection with FROM it chooses columns from given table ( tables )Syntax
SELECT `column_name`
FROM `table_name`
Asterisk (*) placed after SELECT chooses all columns from table
Example
Display names and surnames
| name | surname | age |
|---|---|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT `name`,`surname`
FROM `people`
result
| name | surname |
|---|---|
| Paweł | Kowalski |
| Piotr | Janik |
| Michał | Nowak |
