Difference between revisions of "SELECT"

From SQLZOO
Jump to: navigation, search
(Blanked the page)
 
(33 intermediate revisions by 13 users not shown)
Line 1: Line 1:
<div class=params>schema:scott</div>
 
The table <code>games</code> shows the year and the city hosting the Olympic Games.
 
<table border='1'>
 
<caption>games</caption>
 
<tr> <th>yr</th> <th>city</th> </tr>
 
<tr> <td align='right'>2000</td> <td>Sydney</td> </tr>
 
<tr> <td align='right'>2004</td> <td>Athens</td> </tr>
 
<tr> <td align='right'>2008</td> <td>Beijing</td> </tr>
 
<tr> <td align='right'>2012</td> <td>London</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
 
<code>yr</code> and <code>city</code>.
 
<div class=tidy>
 
DROP TABLE games;
 
</div>
 
<div class=setup>
 
CREATE TABLE games(yr INT, city VARCHAR(20));
 
INSERT INTO games(city,yr) VALUES ('Sydney',2000);
 
INSERT INTO games(city,yr) VALUES ('Athens',2004);
 
INSERT INTO games(city,yr) VALUES ('Beijing',2008);
 
INSERT INTO games(city,yr) VALUES ('London',2012);
 
</div>
 
<div class=def>
 
SELECT yr, city FROM games
 
</div>
 
</div>
 
  
===See also:===
 
*[[SELECT Tutorial]]
 
*[[SELECT ... WHERE]]
 

Latest revision as of 04:00, 17 April 2014

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense