SELECT

From SQLZOO
Revision as of 14:59, 25 May 2013 by Serdizzyk (Talk | contribs)

Jump to: navigation, search

A SELECT statement gets data from a table. Each table contains rows and columns - you can SELECT some columns and ignore others

  • The column names on the select line control which columns you get
  • The FROM clause controls which table you access

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

authors
AUTHOR_ID NAME
1 Shevchenko
2 Franko
3 Lesya
4 Nestaiko
5 Vasyliv
book
BOOK_ID AUTHOR_ID NAMETYPE
1 4 School adventuresRoman
2 3 Forest songPoema
3 1CobzarVirshi
4 2Stolen happiness Povist
5 4 Moon rabbitsRoman
6 4 Sun rabbitsRoman
7 2Fox Mykyta Poema
8 3Cool baby Poema
9 4Muhoos from Vasyukivka Roman

The SELECT statement returns results from a table. In this example the table is games and the columns are yr and city.

DROP TABLE games;

CREATE TABLE games(yr INT, city VARCHAR(20),y1 INT); INSERT INTO games(city,yr) VALUES ('Sydney',2000); INSERT INTO games(city,yr,y1) VALUES ('Athens',2004,2000); INSERT INTO games(city,yr,y1) VALUES ('Beijing',2008,2004); INSERT INTO games(city,yr,y1) VALUES ('London',2012,2008);

SELECT yr, city FROM games

See also:

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense