SELECT - Revision history

15.211.201.82 at 16:59, 22 January 2013

2013-01-22T16:59:13Z

110.93.196.59 at 08:03, 3 January 2013

2013-01-03T08:03:24Z

110.93.196.59 at 07:58, 3 January 2013

2013-01-03T07:58:54Z

110.93.196.59 at 07:57, 3 January 2013

2013-01-03T07:57:24Z

JesseTG: Fixed the two internal links at the bottom

2012-12-29T04:20:19Z

Fixed the two internal links at the bottom

120.107.155.51 at 01:44, 24 December 2012

2012-12-24T01:44:56Z

125.19.34.4 at 09:57, 20 December 2012

2012-12-20T09:57:59Z

125.19.34.4 at 09:53, 20 December 2012

2012-12-20T09:53:27Z

125.19.34.4 at 09:51, 20 December 2012

2012-12-20T09:51:18Z

212.18.201.14: Undo revision 2771 by Connor (talk)

2012-12-04T15:26:37Z

Undo revision 2771 by Connor (talk)

@@ Line 2: / Line 2: @@
 *The column names on the select line control which columns you get
 *The FROM clause controls which table you access
 The table <code>games</code> shows the year and the city hosting the Olympic Games.
 <table border='1'>

@@ Line 3: / Line 3: @@
 *The FROM clause controls which table you access
 <div class=params>schema:scott</div>
-The table <code>EMP</code> shows the year and the city hosting the Olympic Games.
+The table <code>games</code> shows the year and the city hosting the Olympic Games.
 <table border='1'>
-<caption>EMP</caption>
+<caption>games</caption>
-<tr> <th>ENAME</th> <th>JOB</th> <th>SAL</th></tr>
+<tr> <th>yr</th> <th>city</th> <th>y1</th></tr>
-<tr> <td align='right'>SMITH</td> <td>CLERK</td>  <td>800</td></tr>
+<tr> <td align='right'>2000</td> <td>Sydney</td>  <td></td></tr>
-<tr> <td align='right'>ALLEN</td> <td>SALESMAN</td> <td>1600</td></tr>
+<tr> <td align='right'>2004</td> <td>Athens</td> <td>2000</td></tr>
-<tr> <td align='right'>WARD</td> <td>SALESMAN</td><td>1250</td> </tr>
+<tr> <td align='right'>2008</td> <td>Beijing</td><td>2004</td> </tr>
-<tr> <td align='right'>MARTIN</td> <td>SALESMAN</td><td>1250</td> </tr>
+<tr> <td align='right'>2012</td> <td>London</td><td>2008</td> </tr>
 </table>
 <div class=qu>
 The SELECT statement returns results from a <i>table</i>.
-In this example the table is <code>EMP</code> and the columns are
+In this example the table is <code>games</code> and the columns are
-<code>ENAME</code> and <code>JOB</code>.
+<code>yr</code> and <code>city</code>.
 <div class=tidy>
-DROP TABLE EMP;
+DROP TABLE games;
 </div>
 <div class=setup>
-CREATE TABLE EMP(ENAME INT, JOB VARCHAR(20),SAL INT);
+CREATE TABLE games(yr INT, city VARCHAR(20),y1 INT);
-INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('SMITH','CLERK',800);
+INSERT INTO games(city,yr) VALUES ('Sydney',2000);
-INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('ALLEN',SALESMAN,1600);
+INSERT INTO games(city,yr,y1) VALUES ('Athens',2004,2000);
-INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('WARD',SALESMAN,1250);
+INSERT INTO games(city,yr,y1) VALUES ('Beijing',2008,2004);
-INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('MARTIN',SALESMAN,1250);
+INSERT INTO games(city,yr,y1) VALUES ('London',2012,2008);
 </div>
 <div class=def>
-SELECT ENAME, JOB FROM games
+SELECT yr, city FROM games
 </div>
 </div>

@@ Line 11: / Line 11: @@
 <tr> <td align='right'>WARD</td> <td>SALESMAN</td><td>1250</td> </tr>
 <tr> <td align='right'>MARTIN</td> <td>SALESMAN</td><td>1250</td> </tr>
 </table>
 <div class=qu>
@@ Line 29: / Line 25: @@
 INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('WARD',SALESMAN,1250);
 INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('MARTIN',SALESMAN,1250);
 </div>
 <div class=def>

@@ Line 3: / Line 3: @@
 *The FROM clause controls which table you access
 <div class=params>schema:scott</div>
-The table <code>games</code> shows the year and the city hosting the Olympic Games.
+The table <code>EMP</code> shows the year and the city hosting the Olympic Games.
 <table border='1'>
-<caption>games</caption>
+<caption>EMP</caption>
-<tr> <th>yr</th> <th>city</th> <th>y1</th></tr>
+<tr> <th>ENAME</th> <th>JOB</th> <th>SAL</th></tr>
-<tr> <td align='right'>2000</td> <td>Sydney</td>  <td></td></tr>
+<tr> <td align='right'>SMITH</td> <td>CLERK</td>  <td>800</td></tr>
-<tr> <td align='right'>2004</td> <td>Athens</td> <td>2000</td></tr>
+<tr> <td align='right'>ALLEN</td> <td>SALESMAN</td> <td>1600</td></tr>
-<tr> <td align='right'>2008</td> <td>Beijing</td><td>2004</td> </tr>
+<tr> <td align='right'>WARD</td> <td>SALESMAN</td><td>1250</td> </tr>
-<tr> <td align='right'>2012</td> <td>London</td><td>2008</td> </tr>
+<tr> <td align='right'>MARTIN</td> <td>SALESMAN</td><td>1250</td> </tr>
 </table>
 <div class=qu>
 The SELECT statement returns results from a <i>table</i>.
-In this example the table is <code>games</code> and the columns are
+In this example the table is <code>EMP</code> and the columns are
-<code>yr</code> and <code>city</code>.
+<code>ENAME</code> and <code>JOB</code>.
 <div class=tidy>
-DROP TABLE games;
+DROP TABLE EMP;
 </div>
 <div class=setup>
-CREATE TABLE games(yr INT, city VARCHAR(20),y1 INT);
+CREATE TABLE EMP(ENAME INT, JOB VARCHAR(20),SAL INT);
-INSERT INTO games(city,yr) VALUES ('Sydney',2000);
+INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('SMITH','CLERK',800);
-INSERT INTO games(city,yr,y1) VALUES ('Athens',2004,2000);
+INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('ALLEN',SALESMAN,1600);
-INSERT INTO games(city,yr,y1) VALUES ('Beijing',2008,2004);
+INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('WARD',SALESMAN,1250);
-INSERT INTO games(city,yr,y1) VALUES ('London',2012,2008);
+INSERT INTO EMP(ENAME,JOB, SAL) VALUES ('MARTIN',SALESMAN,1250);
 </div>
 <div class=def>
-SELECT yr, city FROM games
+SELECT ENAME, JOB FROM games
 </div>
 </div>

@@ Line 32: / Line 32: @@
 ===See also:===
-*[http://sqlzoo.net/w/index.php/SELECT_from_BBC_Tutorial SELECT Tutorial] - practice using the SELECT command
+*[[SELECT_basics | SELECT Tutorial]] - practice using the SELECT command
-*[SELECT_.._WHERE  |SELECT ... WHERE] - the WHERE clause allows you to get some rows but not others
+*[[SELECT_.._WHERE  |SELECT ... WHERE]] - the WHERE clause allows you to get some rows but not others

@@ Line 21: / Line 21: @@
 <div class=setup>
 CREATE TABLE games(yr INT, city VARCHAR(20),y1 INT);
-INSERT INTO games(city,yr) VALUES ('ouroalpha',2000);
+INSERT INTO games(city,yr) VALUES ('Sydney',2000);
 INSERT INTO games(city,yr) VALUES ('Athens',2004,2000);
 INSERT INTO games(city,yr) VALUES ('Beijing',2008,2004);