Difference between revisions of "CREATE VIEW"
From SQLZOO
| Line 27: | Line 27: | ||
SELECT * FROM old_games; | SELECT * FROM old_games; | ||
</source> | </source> | ||
| − | <source> | + | <source lang='sql' class='def'> |
CREATE VIEW old_games AS | CREATE VIEW old_games AS | ||
SELECT yr,city FROM games | SELECT yr,city FROM games | ||
Revision as of 11:39, 17 July 2012
CREATE VIEW
The table games shows the year and the city hosting the Olympic Games.
| yr | city |
|---|---|
| 2004 | Athens |
| 2008 | Beijing |
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');
The CREATE VIEW names a SELECT query. That query may be used as if it were a table in many contexts. In this example the VIEW old_games shows those games before 2006.
CREATE VIEW old_games AS SELECT yr,city FROM scott.games WHERE yr<2006; SELECT * FROM old_games;
CREATE VIEW old_games AS SELECT yr,city FROM games WHERE yr<2006; SELECT * FROM old_games;
See also
