Difference between revisions of "Get the first 10 rows of the gisq.cia table."

From SQLZOO
Jump to: navigation, search
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
Get the first 10 rows of the bbc table.
 
Get the first 10 rows of the bbc table.
 
<div class='ht'>
 
<div class='ht'>
 +
<div class=params>schema:gisq</div>
 
<source lang=sql class='tidy'></source>
 
<source lang=sql class='tidy'></source>
 
<source lang=sql class='setup'></source>
 
<source lang=sql class='setup'></source>

Revision as of 14:43, 12 July 2012

Get the first 10 rows of the bbc table.

schema:gisq
SELECT * FROM bbc FETCH FIRST 10 ROWS ONLY
SELECT TOP 10 * FROM bbc
SELECT * FROM bbc WHERE rownum<=10
SELECT TOP 10 * FROM bbc
Unknown - please email if you know
set rowcount 10;
select * from bbc;
set rowcount 0
SELECT * FROM bbc LIMIT 10