SELECT
From SQLZoo
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.
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