Difference between revisions of "SELECT"
From SQLZOO
(→Warming up) |
|||
| Line 1: | Line 1: | ||
| − | + | The table <code>games</code> shows the year and the city hosting the Olympic Games. | |
| − | + | <table border='1'> | |
| − | <table | + | <caption>games</caption> |
| − | < | + | <tr> <th>yr</th> <th>city</th> </tr> |
| − | < | + | <tr> <td align='right'>2000</td> <td>Sydney</td> </tr> |
| − | + | <tr> <td align='right'>2004</td> <td>Athens</td> </tr> | |
| − | <th> | + | <tr> <td align='right'>2008</td> <td>Beijing</td> </tr> |
| − | + | <tr> <td align='right'>2012</td> <td>London</td> </tr> | |
| − | </tr> | + | |
| − | <tr> | + | |
| − | + | ||
| − | + | ||
| − | <td align='right'> | + | |
| − | <td | + | |
| − | + | ||
| − | </tr> | + | |
| − | <tr> | + | |
| − | + | ||
| − | + | ||
| − | <td align='right'> | + | |
| − | <td | + | |
| − | + | ||
| − | </tr> | + | |
| − | <tr> | + | |
| − | + | ||
| − | + | ||
| − | <td align='right'> | + | |
| − | <td | + | |
| − | + | ||
| − | </tr> | + | |
| − | <tr> | + | |
| − | + | ||
| − | + | ||
| − | <td align='right'> | + | |
| − | <td | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | </tr> | + | |
</table> | </table> | ||
| − | + | <div class=qu> | |
| − | + | The SELECT statement returns results from a <i>table</i>. | |
| − | <div class= | + | In this example the table is <code>games</code> and the columns are |
| − | + | <code>yr</code> and <code>city</code>. | |
| − | < | + | <div class=tidy> |
| − | + | DROP TABLE games; | |
| − | </ | + | </div> |
| − | + | <div class=setup> | |
| − | < | + | CREATE TABLE games(yr INT, city VARCHAR(20)); |
| − | SELECT | + | 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); | ||
| + | </div> | ||
| + | <div class=def> | ||
| + | SELECT yr, city FROM games | ||
| + | </div> | ||
</div> | </div> | ||
| − | == | + | ===See also:=== |
| − | + | *[[SELECT Tutorial]] | |
| − | + | *[[SELECT ... WHERE]] | |
| − | + | ||
| − | SELECT | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | SELECT | + | |
| − | WHERE | + | |
| − | + | ||
| − | + | ||
Revision as of 19:57, 17 May 2012
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 ('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);
SELECT yr, city FROM games
