select row_number() over(partition packcode order by score desc),packname from T_pack;我的sql中需要按packcode 分区然后按分数score 降序排序后获取顺序号。但是如果score 是0的情况下,不参与排序,请问如何修改这个sql.我使用下面写法,没生效。select row_number() over(partition packcode order by case when score >0 then score else null end ),packname from T_pack;
UNION ALL
SELECT NULL,packname from T_pack WEHRE SCORE=0
可以吗?