您的当前位置:TAGS -> runum
  • MYSQL中替换oracle中runum用法

    数据库2025年06月06日

    一 、 SELECT * FROM (SELECT A.*, rownum AS RN FROM (SELECT (@rownum := @rownum + 1) AS rownum, B.LL11, B.KS01 FROM TA_HISTORY B,(SELECT @rownum := 0) r WHERE 1 = 1 AND B.KS01 &g...