mysql5.7版本的窗口函数实现

因为mysql5.7没有窗口函数，但是实际上还需要实现该功能，这边将两个进行比较对比实现。

-- 一、窗口函数处理 select   ROW_NUMBER OVER(PARTITION BY  QYMC,JCSJ,PKMC  ORDER BY YZMC)  as row_cnt ,QYMC,JCSJ,PKMC,JCZ,WRWPFL from   t_sjzx_wryzxjc_fs_rsj where   PKMC NOT LIKE '%进口%' ;   -- 二、若没有窗口函数，利用其它方式实现ROW_NUMBER OVER() select   -- 注意这个计数项一定要放在变量设置之前，若出现和初始设置不一致才会出现1，否则就自增 if( @QYMC=a.QYMC  and @PKMC = a.PKMC and  @JCSJ=a.JCSJ ,  @curRank := @curRank +1 ,@curRank := 1  )  as row_cnt ,@QYMC := a.QYMC ,@JCSJ := a.JCSJ ,@PKMC := a.PKMC ,a.JCZ ,a.WRWPFL from  -- 原“PARTITION BY  QYMC,JCSJ,PKMC  ORDER BY YZMC”，需要在这里将所有进行 order by  进行排序 (select *   from  t_sjzx_wryzxjc_fs_rsj   WHERE  PKMC NOT LIKE '%进口%'  ORDER BY  QYMC,JCSJ,PKMC,YZMC ) a, (select  @QYMC := null,@PKMC := null,@JCSJ := null,@curRank := 0) t_temp;