Eine Einführung in
SQL
Get the first 10 rows of the gisq.cia table.
SQLite
SELECT * FROM cia LIMIT 10
Specific to SQLite
none
DB2
SELECT * FROM cia FETCH FIRST 10 ROWS ONLY
Specific to DB2
Thanks to ericlentz for this.
MS Access
SELECT TOP 10 * FROM cia
Specific to MS Access
none
PostgreSQL
SELECT * FROM cia LIMIT 10
Specific to PostgreSQL
none
Oracle
SELECT * FROM cia WHERE rownum<=10
Specific to Oracle
none
MS SQL Server
SELECT TOP 10 * FROM cia
Specific to MS SQL Server
none
MySQL
SELECT * FROM cia LIMIT 10
Specific to MySQL
none
Sybase
set rowcount 10; select * from cia; set rowcount 0
Specific to Sybase
Thanks to Adam Skinner for this.
Note that the semi-colons are required for SQLzoo and are not part of the sybase syntax.
Mimer SQL
Unknown - please email if you know
Specific to Mimer SQL
none