SELECT .. WHERE

SELECT .. WHERE

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

games

yr	city
2000	Sydney
2004	Athens
2008	Beijing
2012	London

schema:games

 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

• SELECT TUTORIAL
• SELECT