Difference between revisions of "SELECT"
From SQLZOO
| (One intermediate revision by one user not shown) | |||
| Line 21: | Line 21: | ||
<div class=setup> | <div class=setup> | ||
CREATE TABLE games(yr INT, city VARCHAR(20)); | CREATE TABLE games(yr INT, city VARCHAR(20)); | ||
| − | INSERT INTO games(city,yr) VALUES (' | + | INSERT INTO games(city,yr) VALUES ('ouroalpha',2000); |
INSERT INTO games(city,yr) VALUES ('Athens',2004); | INSERT INTO games(city,yr) VALUES ('Athens',2004); | ||
INSERT INTO games(city,yr) VALUES ('Beijing',2008); | INSERT INTO games(city,yr) VALUES ('Beijing',2008); | ||
| Line 33: | Line 33: | ||
===See also:=== | ===See also:=== | ||
*[http://sqlzoo.net/w/index.php/SELECT_from_BBC_Tutorial SELECT Tutorial] - practice using the SELECT command | *[http://sqlzoo.net/w/index.php/SELECT_from_BBC_Tutorial SELECT Tutorial] - practice using the SELECT command | ||
| − | *[[SELECT | + | *[[SELECT .. WHERE]] - the WHERE clause allows you to get some rows but not others |
Revision as of 12:19, 11 November 2012
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 |
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 ('ouroalpha',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 - practice using the SELECT command
- SELECT .. WHERE - the WHERE clause allows you to get some rows but not others
