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
2000	Sydney
2004	Athens
2008	Beijing
2012	London
2016	Rio

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; DROP TABLE games CASCADE;

CREATE TABLE games(yr INT, city VARCHAR(20),y1 INT); 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); INSERT INTO games(city,yr) VALUES ('London',2012); INSERT INTO games(city,yr) VALUES ('Rio',2016);

SELECT yr, city FROM games