SELECT

schema:scott

The table games shows the year and the city hosting the Olympic Games.

games

yr	city
2000	Sydney
2004	Athens
2008	Beijing
2012	London

The SELECT statement returns results from a table. In this example the table is games and the columns are yr and city.

DROP TABLE games;

CREATE TABLE games(yr INT, city VARCHAR(20)); INSERT INTO games(city,yr) VALUES ('Sydney',2000); INSERT INTO games(city,yr) VALUES ('Athens',2004); INSERT INTO games(city,yr) VALUES ('Beijing',2008); INSERT INTO games(city,yr) VALUES ('London',2012);

SELECT yr, city FROM games

See also:

• SELECT Tutorial
• SELECT ... WHERE