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

From SQLZOO
Revision as of 14:30, 11 July 2012 by Connor (talk | contribs) (Created page with "Get the first 10 rows of the gisq.cia table. <div class='ht'> <source lang=sql class='tidy'> <source lang='sql' class='def e-db2'>SELECT * FROM cia FETCH FIRST 10 ROWS ONLY </...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

<source lang='sql' class='def e-db2'>SELECT * FROM cia FETCH FIRST 10 ROWS ONLY
SELECT TOP 10 * FROM cia
SELECT * FROM cia WHERE rownum<=10
SELECT TOP 10 * FROM cia
Unknown - please email if you know
set rowcount 10;
select * from cia;
set rowcount 0
SELECT * FROM cia LIMIT 10