db2 取数据 前十条 后十条

db2 数据库 取最老的十条数据

select * from tablename where 1=1 fetch first 10 rows only

 

取最新的十条数据top(10)

select * from tablename where 1=1 order by id desc  fetch first 10 rows only