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

From SQLZoo
Jump to navigation Jump to search

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
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects