Difference between revisions of "SELECT .. WHERE"
From SQLZOO
| (4 intermediate revisions by 3 users not shown) | |||
| Line 11: | Line 11: | ||
</table> | </table> | ||
<div class='ht'> | <div class='ht'> | ||
| − | <div class=params>schema: | + | <div class=params>schema:games</div> |
<source lang=sql class='tidy'> DROP TABLE games</source> | <source lang=sql class='tidy'> DROP TABLE games</source> | ||
<source lang=sql class='setup'> CREATE TABLE games( | <source lang=sql class='setup'> CREATE TABLE games( | ||
yr INTEGER PRIMARY KEY, | yr INTEGER PRIMARY KEY, | ||
| − | city VARCHAR( | + | city VARCHAR(20)); |
| − | INSERT INTO games VALUES (2000,Sydney); | + | INSERT INTO games VALUES (2000,'Sydney'); |
| − | INSERT INTO games VALUES (2004,Athens); | + | INSERT INTO games VALUES (2004,'Athens'); |
| − | INSERT INTO games VALUES (2008,Beijing); | + | INSERT INTO games VALUES (2008,'Beijing'); |
| − | INSERT INTO games VALUES (2012,London); | + | INSERT INTO games VALUES (2012,'London'); |
</source> | </source> | ||
The SELECT statement returns results from a <i>table</i>. | The SELECT statement returns results from a <i>table</i>. | ||
| Line 26: | Line 26: | ||
<source lang='sql' class='def e-oracle'> | <source lang='sql' class='def e-oracle'> | ||
SELECT yr, city | SELECT yr, city | ||
| − | FROM | + | FROM scott.games |
WHERE yr = 2004 | WHERE yr = 2004 | ||
</source> | </source> | ||
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
