SELECT

From SQLZoo
Jump to navigation Jump to search

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

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects