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

From SQLZOO
Revision as of 10:13, 12 July 2012 by Connor (Talk | contribs)

Jump to: navigation, search

Get the first 10 rows of the bbc table.

<SOURCE lang='sql' class='def e-db2'>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
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense