Get the first 10 rows of the gisq.cia table. - Revision history

Connor at 14:43, 12 July 2012

2012-07-12T14:43:53Z

2012-07-12T14:42:40Z

2012-07-12T14:40:49Z

2012-07-12T14:04:39Z

2012-07-12T09:13:28Z

@@ Line 1: / Line 1: @@
 Get the first 10 rows of the bbc table.
 <div class='ht'>
-<div class=params>schema:scott</div>
+<div class=params>schema:gisq</div>
 <source lang=sql class='tidy'></source>
 <source lang=sql class='setup'></source>

@@ Line 1: / Line 1: @@
 Get the first 10 rows of the bbc table.
 <div class='ht'>
-<div class=params>schema:gisq</div>
+<div class=params>schema:scott</div>
 <source lang=sql class='tidy'></source>
 <source lang=sql class='setup'></source>

@@ Line 1: / Line 1: @@
 Get the first 10 rows of the bbc table.
 <div class='ht'>
 <source lang=sql class='tidy'></source>
 <source lang=sql class='setup'></source>

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

@@ Line 1: / Line 1: @@
-Get the first 10 rows of the gisq.cia table.
+Get the first 10 rows of the bbc table.
 <div class='ht'>
 <source lang=sql class='tidy'>
-<source lang='sql' class='def e-db2'>SELECT * FROM cia FETCH FIRST 10 ROWS ONLY
+<source lang='sql' class='def e-db2'>SELECT * FROM bbc FETCH FIRST 10 ROWS ONLY
 </source>
-<source lang='sql' class='def e-access'>SELECT TOP 10 * FROM cia
+<source lang='sql' class='def e-access'>SELECT TOP 10 * FROM bbc
 </source>
-<source lang='sql' class='def e-oracle'>SELECT * FROM cia WHERE rownum<=10
+<source lang='sql' class='def e-oracle'>SELECT * FROM bbc WHERE rownum<=10
 </source>
-<source lang='sql' class='def e-sqlserver'>SELECT TOP 10 * FROM cia
+<source lang='sql' class='def e-sqlserver'>SELECT TOP 10 * FROM bbc
 </source>
 <source lang='sql' class='def e-mimer'>Unknown - please email if you know
 </source>
 <source lang='sql' class='def e-sybase'>set rowcount 10;
-select * from cia;
+select * from bbc;
 set rowcount 0
 </source>
-<source lang='sql' class='def'>SELECT * FROM cia LIMIT 10
+<source lang='sql' class='def'>SELECT * FROM bbc LIMIT 10
 </source>
 <div class="ecomm e-db2" style="display: none">Thanks to ericlentz for this</div>