一、关于先分组(PARTITION BY XMMC) 再将每组数据单独按时间排序DAT 并且编号ID。
SELECT ROW_NUMBER() OVER (PARTITION BY XMMC ORDER BY GL_YH_DLJD_DAT DESC) as ID,
XMMC,GL_YH_DLJD_DAT DAT,GL_YH_DLJD_WCGZ W,ZJH Z,GL_YH_DLJD_WCLC LC
from RN_CONSTRUCTION
一、关于先分组(PARTITION BY XMMC) 再将每组数据单独按时间排序DAT 并且编号ID。
SELECT ROW_NUMBER() OVER (PARTITION BY XMMC ORDER BY GL_YH_DLJD_DAT DESC) as ID,
XMMC,GL_YH_DLJD_DAT DAT,GL_YH_DLJD_WCGZ W,ZJH Z,GL_YH_DLJD_WCLC LC
from RN_CONSTRUCTION