SELECT TOP
It is a real pain in the ... that every sql server uses it's own select top equivelent... Here follows a list of some of the ones I found:
SQL Server: SELECT TOP 10 * FROM [TABLE]
DB2: SELECT * FROM [TABLE] FETCH FIRST 10 ROWS ONLY
PostgreSQL: SELECT * FROM [TABLE] LIMIT 10
Oracle: SELECT * FROM [TABLE] WHERE ROWNUM <= 10
Sybase: SET ROWCOUNT 10 SELECT * FROM [TABLE]
Firebird: SELECT FIRST 10 * FROM [TABLE]
MySQL: SELECT * FROM [TABLE] LIMIT 10
I haven't tested all of these... I only needed the SQL Server and MySQL statements but will supply the rest as reference!!!