SELECT .. WHERE - Revision history

Andr3w at 01:06, 1 March 2013

2013-03-01T01:06:02Z

2013-01-22T17:32:56Z

2012-12-16T15:53:23Z

2012-12-16T09:55:13Z

2012-12-16T09:53:59Z

2012-07-17T08:52:55Z

2012-07-17T08:15:35Z

2012-07-16T15:37:32Z

The table games shows the year and the city hosting the Olympic Games.

games
2012-07-16T15:37:02Z 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..." New page <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 align='center'>'''yr'''</th><th align='center'>'''city'''</th></tr> <tr><td>2000</td><td align='left'>Sydney</td></tr> <tr><td>2004</td><td align='left'>Athens</td></tr> <tr><td>2008</td><td align='left'>Beijing</td></tr> <tr><td>2012</td><td align='left'>London</td></tr> <div class='ht'> The SELECT statement returns results from a table. With a WHERE clause only some rows are returned. In this example shows the year that Athens hosted the Olympic games. <div class=params>schema:scott</div> <source lang='sql' class='def e-oracle'> SELECT yr, city FROM gisq.games </source> <source lang='sql' class='def'> SELECT yr, city FROM games </source> </div> <p>See also</p> <ul> <li>[[SELECT_from_BBC_Tutorial \|SELECT TUTORIAL]]</li> <li>[[SELECT \|SELECT]]</li> </ul>

@@ Line 11: / Line 11: @@
 </table>
 <div class='ht'>
 <source lang=sql class='tidy'> DROP TABLE games</source>
 <source lang=sql class='setup'> CREATE TABLE games(

@@ Line 11: / Line 11: @@
 </table>
 <div class='ht'>
-<div class=params>schema:scott</div>
+<div class=params>schema:games</div>
 <source lang=sql class='tidy'> DROP TABLE games</source>
 <source lang=sql class='setup'> CREATE TABLE games(

@@ Line 9: / Line 9: @@
 <tr><td>2008</td><td align='left'>Beijing</td></tr>
 <tr><td>2012</td><td align='left'>London</td></tr>
 </table>
 <div class='ht'>
@@ Line 22: / Line 20: @@
 INSERT INTO games VALUES (2008,'Beijing');
 INSERT INTO games VALUES (2012,'London');
 </source>
 The SELECT statement returns results from a <i>table</i>.

@@ Line 23: / Line 23: @@
 INSERT INTO games VALUES (2012,'London');
 INSERT INTO games VALUES (2012,'india');
-INSERT INTO games VALUES (2012,'uk');
+INSERT INTO games VALUES (2004,'uk');
 </source>
 The SELECT statement returns results from a <i>table</i>.

@@ Line 9: / Line 9: @@
 <tr><td>2008</td><td align='left'>Beijing</td></tr>
 <tr><td>2012</td><td align='left'>London</td></tr>
 </table>
 <div class='ht'>
@@ Line 20: / Line 22: @@
 INSERT INTO games VALUES (2008,'Beijing');
 INSERT INTO games VALUES (2012,'London');
 </source>
 The SELECT statement returns results from a <i>table</i>.

@@ Line 11: / Line 11: @@
 </table>
 <div class='ht'>
-<div class=params>schema:gisq</div>
+<div class=params>schema:scott</div>
 <source lang=sql class='tidy'> DROP TABLE games</source>
 <source lang=sql class='setup'> CREATE TABLE games(
    yr INTEGER PRIMARY KEY,
-   city VARCHAR(10));
+   city VARCHAR(20));
-INSERT INTO games VALUES (2000,Sydney);
+INSERT INTO games VALUES (2000,'Sydney');
-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>
 The SELECT statement returns results from a <i>table</i>.
@@ Line 26: / Line 26: @@
 <source lang='sql' class='def e-oracle'>
 SELECT yr, city
-FROM gisq.games
+FROM scott.games
 WHERE yr = 2004
 </source>