Difference between revisions of "SELECT Reference"

From SQLZOO
Jump to: navigation, search
(Created page with "How to read data {{SELECT Ref}}")
 
Line 1: Line 1:
How to read data
 
 
{{SELECT Ref}}
 
{{SELECT Ref}}
 +
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:
 +
<source lang='sql'>
 +
SELECT name, population
 +
  FROM bbc
 +
WHERE region='North America'
 +
</source>

Revision as of 11:02, 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