Difference between revisions of "SELECT"
|(4 intermediate revisions by one user not shown)|
|Line 32:||Line 32:|
*[SELECT Tutorial] - practice using the SELECT command
*[[SELECT .. WHERE]] - the WHERE clause allows you to get some rows but not others
Revision as of 19:04, 4 September 2012
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
games shows the year and the city hosting the Olympic Games.
The SELECT statement returns results from a table.
In this example the table is
games and the columns are
DROP TABLE games;
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);
SELECT yr, city FROM games