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
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