Difference between revisions of "Get the first 10 rows of the gisq.cia table."
From SQLZOO
| (One intermediate revision by one user not shown) | |
Latest 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
Get the first 10 rows of the gisq.cia table.
