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

Latest revision as of 15: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

Get the first 10 rows of the gisq.cia table.

@@ Line 1: / Line 1: @@
 Get the first 10 rows of the bbc table.
 <div class='ht'>
-<source lang=sql class='tidy'>
+<div class=params>schema:gisq</div>
+<source lang=sql class='tidy'></source>
+<source lang=sql class='setup'></source>
 <source lang='sql' class='def e-db2'>SELECT * FROM bbc FETCH FIRST 10 ROWS ONLY
 </source>