Difference between revisions of "SELECT .. WHERE"
From SQLZOO
| Line 11: | Line 11: | ||
</table> | </table> | ||
<div class='ht'> | <div class='ht'> | ||
| − | The SELECT statement returns results from a table. | + | <div class=params>schema:gisq</div> |
| + | <source lang=sql class='tidy'> DROP TABLE games</source> | ||
| + | <source lang=sql class='setup'> CREATE TABLE games( | ||
| + | yr INTEGER PRIMARY KEY, | ||
| + | city VARCHAR(10)); | ||
| + | INSERT INTO games VALUES (2000,Sydney); | ||
| + | INSERT INTO games VALUES (2004,Athens); | ||
| + | INSERT INTO games VALUES (2008,Beijing); | ||
| + | INSERT INTO games VALUES (2012,London); | ||
| + | </source> | ||
| + | The SELECT statement returns results from a <i>table</i>. | ||
With a WHERE clause only some rows are returned. | With a WHERE clause only some rows are returned. | ||
| − | + | This example shows the year that Athens hosted the Olympic games. | |
| − | < | + | <source lang='sql' class='def e-oracle'> |
| + | SELECT yr, city | ||
| + | FROM gisq.games | ||
| + | WHERE yr = 2004 | ||
| + | </source> | ||
<source lang='sql' class='def'> | <source lang='sql' class='def'> | ||
SELECT yr, city | SELECT yr, city | ||
FROM games | FROM games | ||
| + | WHERE yr = 2004 | ||
</source> | </source> | ||
</div> | </div> | ||
Revision as of 08:15, 17 July 2012
SELECT .. WHERE
The table games shows the year and the city hosting the Olympic Games.
| yr | city |
|---|---|
| 2000 | Sydney |
| 2004 | Athens |
| 2008 | Beijing |
| 2012 | London |
schema:gisq
DROP TABLE games
CREATE TABLE games( yr INTEGER PRIMARY KEY, city VARCHAR(10)); INSERT INTO games VALUES (2000,Sydney); INSERT INTO games VALUES (2004,Athens); INSERT INTO games VALUES (2008,Beijing); INSERT INTO games VALUES (2012,London);
The SELECT statement returns results from a table. With a WHERE clause only some rows are returned. This example shows the year that Athens hosted the Olympic games.
SELECT yr, city FROM gisq.games WHERE yr = 2004
SELECT yr, city FROM games WHERE yr = 2004
See also
