Difference between revisions of "SELECT Reference"

From SQLZOO
Jump to: navigation, search
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{SELECT Ref}}
+
CREATE TABLE emp (ID NUMBER, name VARCHAR2(40));
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:
 
<div class='ht'>
 
<source lang='sql'>
 
SELECT name, population
 
  FROM bbc
 
WHERE region='North America'
 
</source>
 
</div>
 

Revision as of 11:13, 9 January 2013

CREATE TABLE emp (ID NUMBER, name VARCHAR2(40));