MySQL 5.7实现 row_number窗口函数

SELECT pzrq,pzbh,pzlx,'example-1001','演示账套',id AS vou_id,subjcode,kmmc,zy,jfje,dfje,0,0, if(@pzrq = pz.pzrq AND @pzbh = pz.pzbh and @pzlx = pz.pzlx, @
posted @ 2020-03-23 15:32  Wind_LPH  阅读(4422)  评论(0)  编辑  收藏  举报