不同数据库查询一行数据sql

不同数据库查询一行数据sql:

DB2
select * from tablename fetch first 1 rows only;

SqlServer
select top 1 * from tablename;

Informix
select first 1 * from tablename;

Oralce
select * from tablename where rownum<=1;

MySql
select * from tableName limit 1;