几大数据库返回前n行的关键字

Oracle

select * from table where rownum < x;

 

db2

select * from table fetch first x rows only;

 

teradata

select top x * from table;