Difference between revisions of "SELECT .. WHERE"

From SQLZOO
Jump to: navigation, search
 
(5 intermediate revisions by 4 users not shown)
Line 11: Line 11:
 
</table>
 
</table>
 
<div class='ht'>
 
<div class='ht'>
<div class=params>schema:gisq</div>
 
 
<source lang=sql class='tidy'> DROP TABLE games</source>
 
<source lang=sql class='tidy'> DROP TABLE games</source>
 
<source lang=sql class='setup'> CREATE TABLE games(
 
<source lang=sql class='setup'> CREATE TABLE games(
 
   yr INTEGER PRIMARY KEY,
 
   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>
 
</source>
 
The SELECT statement returns results from a <i>table</i>.  
 
The SELECT statement returns results from a <i>table</i>.  
Line 26: Line 25:
 
<source lang='sql' class='def e-oracle'>
 
<source lang='sql' class='def e-oracle'>
 
SELECT yr, city  
 
SELECT yr, city  
FROM gisq.games
+
FROM scott.games
 
WHERE yr = 2004
 
WHERE yr = 2004
 
</source>  
 
</source>  

Latest revision as of 02:06, 1 March 2013

SELECT .. WHERE

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

games
yrcity
2000Sydney
2004Athens
2008Beijing
2012London
 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 scott.games
WHERE yr = 2004
SELECT yr, city 
FROM games
WHERE yr = 2004

See also

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense