select * from (select ID,WJMC,RANK() over ( order by ID ) case3 from T_ZYGXPT where TYPEID=143 order by T_ZYGXPT.GXSJ asc) as tt where case3 between 1 and 6"
排序之后选择前6条数据
db2查询语句值排序
最新推荐文章于 2023-07-21 14:45:48 发布
select * from (select ID,WJMC,RANK() over ( order by ID ) case3 from T_ZYGXPT where TYPEID=143 order by T_ZYGXPT.GXSJ asc) as tt where case3 between 1 and 6"
排序之后选择前6条数据