db2：

       select * from tab fetch first 10 rows only

  oracle:

      select * from tab where rownum <=10

  sqlserver:

      select top 10 * from tab

  mysql:

      select * from tab limit 10