MySQL替换oracle里ROW_NUMBER () OVER ( PARTITION BY '' ORDER BY ' ' DESC )的方法

ORACLE 语句

SELECT ROW_NUMBER () OVER ( PARTITION BY V1.CABIN_CODE ORDER BY V1.CREATE_DATE DESC ) R1N1, V1.* FROM FARE_VIRTUAL_CABIN_DISCOUNT V1

MySQL 语句

SELECT V1.*,V1.rank  FROM (  
  SELECT  V2.*,
  IF(@CABIN_CODE=V2.CABIN_CODE,@rank:=@rank+1,@rank:=1) AS rank,  
  @CABIN_CODE:=V2.CABIN_CODE  AS ass
  FROM (   
SELECT * FROM FARE_VIRTUAL_CABIN_DISCOUNT  ORDER BY  CREATE_DATE DESC 
  ) V2, 
  (SELECT @rownum :=0 , @V1.CABIN_CODE := NULL ,@rank:=0) A1
)  V1