SQL: SELECT

The SELECT keyword determines which fields an SQL statement will involve. They are taken from the table(s) listed after the FROM keyword.

In the example below, the name and grade fields are being displayed. Note the comma. One is required for each field listed past the first.

SELECT first_name, grade

FROM students;

To get every field without having to explicitly list it out, use an asterisk (*) instead.

SELECT *

FROM students;

Following is an interactive SQL query. Click on the second through fourth fields to add or remove them from the query.

SELECT name, capital, language, population

FROM countries;