Difference between revisions of "SELECT"
From SQLZOO
| Line 2: | Line 2: | ||
*The column names on the select line control which columns you get | *The column names on the select line control which columns you get | ||
*The FROM clause controls which table you access | *The FROM clause controls which table you access | ||
| − | |||
The table <code>games</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'> | <table border='1'> | ||
Latest revision as of 16:59, 22 January 2013
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.
| yr | city | y1 |
|---|---|---|
| 2000 | Sydney | |
| 2004 | Athens | 2000 |
| 2008 | Beijing | 2004 |
| 2012 | London | 2008 |
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
[edit] See also:
- SELECT Tutorial - practice using the SELECT command
- SELECT ... WHERE - the WHERE clause allows you to get some rows but not others
