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

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

Thanks to ericlentz for this

Thanks to Adam Skinner for this. Note that the semi-colons are required for SQLzoo and are not part of the sybase syntax.

Meta Data

What are my tables?

What are the columns of the BBC table?

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

Get the 11th to the 20th rows of the cia table - by population.

What version of the software am I using?

What is the syntax to view structure of table?

How can you determine the primary key using SQL?

Return a sequential record count for all records returned