SELECT * FROM your_table FETCH FIRST 10 ROWS ONLY;， **说明**：这是DB2中最常用的方法之一，用于限制查询结果的行数。其语法简单直观，常用于分页查询和限制结果集。，，2. **使用ROW_NUMBER()函数**， **语法**：`SELECT * FROM (SELECT your_columns, ROW_NUMBER() OVER (ORDER BY your_sort_column) AS row_num FROM your_table) AS subquery WHERE row_num