Difference between revisions of "SELECT Reference"

From SQLZOO
Jump to: navigation, search
Line 5: Line 5:
 
The simplest SELECT commands involve a single table:
 
The simplest SELECT commands involve a single table:
 
<div class='ht'>
 
<div class='ht'>
<source lang='sql'>
+
<source lang='sql' class='sql'>
 
SELECT name, population
 
SELECT name, population
 
   FROM bbc
 
   FROM bbc

Revision as of 11:03, 11 August 2012

The SELECT command is used to show data from a database.

The output from a SELECT statement is always a grid - with a number of rows and a number of columns. The simplest SELECT commands involve a single table:

SELECT name, population
  FROM bbc
 WHERE region='North America'
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense