Difference between revisions of "CREATE VIEW"
From SQLZOO
Miacardenas (Talk | contribs) |
Miacardenas (Talk | contribs) |
||
| Line 1: | Line 1: | ||
<h1>CREATE VIEW</h1> | <h1>CREATE VIEW</h1> | ||
| − | <p>The table <code>games</code> shows the year and the city hosting the Olympic Games.</p> | + | <p>The table <code>games</code> shows the year and the city hosting the Olympic Games. [http://dissertations.biz/writing-service.php http://dissertations.biz/]</p> |
<table> | <table> | ||
<caption align='center'>games</caption> | <caption align='center'>games</caption> | ||
| Line 19: | Line 19: | ||
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 CREATE VIEW names a SELECT query. That query may be used as if it were a table in many contexts. | The CREATE VIEW names a SELECT query. That query may be used as if it were a table in many contexts. | ||
Revision as of 08:36, 22 October 2012
CREATE VIEW
The table games shows the year and the city hosting the Olympic Games. http://dissertations.biz/
| yr | city |
|---|---|
| 2004 | Athens |
| 2008 | Beijing |
schema:scott
DROP TABLE games; DROP TABLE old_games; DROP TABLE og
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 og AS SELECT yr,city FROM scott.games WHERE yr<2006; SELECT * FROM og;
CREATE VIEW og AS SELECT yr,city FROM games WHERE yr<2006; SELECT * FROM og;
See also
