Difference between revisions of "SELECT .. WHERE"
(Created page with " <h1>SELECT .. WHERE</h1> <p>The table <code>games</code> shows the year and the city hosting the Olympic Games.</p> <table> <caption align='center'>games</caption> <tr><th al...") |
|||
| (8 intermediate revisions by 4 users not shown) | |||
| Line 9: | Line 9: | ||
<tr><td>2008</td><td align='left'>Beijing</td></tr> | <tr><td>2008</td><td align='left'>Beijing</td></tr> | ||
<tr><td>2012</td><td align='left'>London</td></tr> | <tr><td>2012</td><td align='left'>London</td></tr> | ||
| + | </table> | ||
<div class='ht'> | <div class='ht'> | ||
| − | The SELECT statement returns results from a table. | + | <source lang=sql class='tidy'> DROP TABLE games</source> |
| + | <source lang=sql class='setup'> 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'); | ||
| + | </source> | ||
| + | The SELECT statement returns results from a <i>table</i>. | ||
With a WHERE clause only some rows are returned. | With a WHERE clause only some rows are returned. | ||
| − | + | This example shows the year that Athens hosted the Olympic games. | |
| − | |||
<source lang='sql' class='def e-oracle'> | <source lang='sql' class='def e-oracle'> | ||
SELECT yr, city | SELECT yr, city | ||
| − | FROM | + | FROM games |
| − | </source> | + | WHERE yr = 2004 |
| + | </source> | ||
<source lang='sql' class='def'> | <source lang='sql' class='def'> | ||
SELECT yr, city | SELECT yr, city | ||
FROM games | FROM games | ||
| + | WHERE yr = 2004 | ||
</source> | </source> | ||
</div> | </div> | ||
Latest revision as of 17:51, 21 March 2016
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 |
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 games
WHERE yr = 2004
SELECT yr, city
FROM games
WHERE yr = 2004
See also
