Difference between revisions of "SELECT .. WHERE"
From SQLZOO
| Line 23: | Line 23: | ||
INSERT INTO games VALUES (2012,'London'); | INSERT INTO games VALUES (2012,'London'); | ||
INSERT INTO games VALUES (2012,'india'); | INSERT INTO games VALUES (2012,'india'); | ||
| − | INSERT INTO games VALUES ( | + | INSERT INTO games VALUES (2004,'uk'); |
</source> | </source> | ||
The SELECT statement returns results from a <i>table</i>. | The SELECT statement returns results from a <i>table</i>. | ||
Revision as of 09:55, 16 December 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 |
| 2012 | india |
| 2012 | uk |
schema:scott
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'); INSERT INTO games VALUES (2012,'india'); INSERT INTO games VALUES (2004,'uk');
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
