Difference between revisions of "SELECT .. WHERE"
|(2 intermediate revisions by one user not shown)|
Revision as of 15:53, 16 December 2012
SELECT .. WHERE
games shows the year and the city hosting the Olympic 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