Difference between revisions of "SELECT .. WHERE"
From SQLZOO
| (5 intermediate revisions by 3 users not shown) | |||
| Line 11: | Line 11: | ||
</table> | </table> | ||
<div class='ht'> | <div class='ht'> | ||
| − | The SELECT statement returns results from a table. | + | <div class=params>schema:games</div> |
| + | <source lang=sql class='tidy'> DROP TABLE games</source> | ||
| + | <source lang=sql class='setup'> CREATE TABLE games( | ||
| + | yr INTEGER PRIMARY KEY, | ||
| + | city VARCHAR(20)); | ||
| + | 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 scott.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 17:32, 22 January 2013
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:games
DROP TABLE games
CREATE TABLE games( yr INTEGER PRIMARY KEY, city VARCHAR(20)); 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 scott.games WHERE yr = 2004
SELECT yr, city FROM games WHERE yr = 2004
See also
