论坛 › DB2 › db2查询语句值排序

小fish 发表于 2016-11-16 08:35:58

db2查询语句值排序

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查询语句值排序