选取记录集的前面N条记录

 1.Sql Server:

   SELECT TOP 10 * FROM [TABLENAME]

2.Oracle:

   SELECT * FROM "TABLENAME" WHERE ROWNUM<=10

3.MySql:
   
   SELECT * FROM `TABLENAME` LIMIT 10

4.DB2

   SELECT * FROM TABLENAME FETCH FIRST 10 ROWS ONLY