Difference between revisions of "Main Page/fr"

From SQLZOO
Jump to: navigation, search
Line 1: Line 1:
 
+
A SELECT statement gets data from a table. Each table contains rows and columns - you can SELECT some columns and ignore others
<p class=slogan><span>SQL apprendre par:</span> SQL Server, Oracle, MySQL, DB2, <span>et</span> PostgreSQL.</p>
+
*The column names on the select line control which columns you get
__NOTOC__
+
*The FROM clause controls which table you access
=== <span style="color:#ee8301;">This page is just a placeholder to test the language selection box at the bottom of this page. If you want to translate the Wiki pages into French language, please feel free to do it.</span> ===
+
<div class=params>schema:scott</div>
 
+
The table <code>games</code> shows the year and the city hosting the Olympic Games.
 
+
<table border='1'>
<div class=tutblock>
+
<caption>games</caption>
==Section tutoriel==
+
<tr> <th>yr</th> <th>city</th> </tr>
...
+
<tr> <td align='right'>2000</td> <td>Sydney</td> </tr>
 +
<tr> <td align='right'>2004</td> <td>Athens</td> </tr>
 +
<tr> <td align='right'>2008</td> <td>Beijing</td> </tr>
 +
<tr> <td align='right'>2012</td> <td>London</td> </tr>
 +
</table>
 +
<div class=qu>
 +
The SELECT statement returns results from a <i>table</i>.
 +
In this example the table is <code>games</code> and the columns are
 +
<code>yr</code> and <code>city</code>.
 +
<div class=tidy>
 +
DROP TABLE games;
 
</div>
 
</div>
<div class='refblock'>
+
<div class=setup>
 
+
CREATE TABLE games(yr INT, city VARCHAR(20));
==Section de référence==
+
INSERT INTO games(city,yr) VALUES ('ouroalpha',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);
 
</div>
 
</div>
<div class='resblock'>
+
<div class=def>
==Resources SQL==
+
SELECT yr, city FROM games
...
+
 
</div>
 
</div>
<div style= "    background:#FFC694;
 
    border: 1px solid #EE8301;
 
    -moz-border-radius:2em;
 
    -webkit-border-radius:2em;
 
    border-radius:2em;
 
    padding: 0.5em 2em;
 
    clear:both;">
 
<p>'''Que pensez-vous de ...'''</p>
 
 
</div>
 
</div>
  
{{Languages}}
+
===See also:===
 +
*[http://sqlzoo.net/w/index.php/SELECT_from_BBC_Tutorial SELECT Tutorial] - practice using the SELECT command
 +
*[SELECT_.._WHERE  |SELECT ... WHERE] - the WHERE clause allows you to get some rows but not others

Revision as of 10:51, 7 December 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
schema:scott

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

games
yr city
2000 Sydney
2004 Athens
2008 Beijing
2012 London

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)); INSERT INTO games(city,yr) VALUES ('ouroalpha',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

See also:

  • SELECT Tutorial - practice using the SELECT command
  • [SELECT_.._WHERE |SELECT ... WHERE] - the WHERE clause allows you to get some rows but not others
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense