SELECT

A SELECT statement gets data from a table. Each table contains rows and columns - you can SELECT some columns and ignore others

• The column names on the select line control which columns you get
• The FROM clause controls which table you access

schema:scott

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

games

yr	city	y1
2000	Sydney
2004	Athens	2000
2008	Beijing	2004
2012	London	2008

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),y1 INT); INSERT INTO games(city,yr) VALUES ('ouroalpha',2000); INSERT INTO games(city,yr) VALUES ('Athens',2004,2000); INSERT INTO games(city,yr) VALUES ('Beijing',2008,2004); INSERT INTO games(city,yr) VALUES ('London',2012,2008);

SELECT yr, city FROM games

See also:

• SELECT Tutorial - practice using the SELECT command
• [SELECT_.._WHERE |SELECT ... WHERE] - the WHERE clause allows you to get some rows but not others