SELECT ROW_NUMBER () OVER ( PARTITION BY REG_NO,MZ_FLAG,BL_TYPE ORDER BY BL_ORDER,BL_TIME ) CNO,BL_ORDNO,REG_NO,MZ_FLAG,BL_TYPE,BL_ORDER FROM EMR_PATIENT_BL_NEW where MZ_FLAG=‘#‘
update EMR_PATIENT_BL_NEW b set b.BL_ORDER=( with t as (select ROW_NUMBER () OVER ( PARTITION BY REG_NO,MZ_FLAG,BL_TYPE ORDER BY BL_ORDER,BL_TIME ) CNO,BL_ORDNO FROM EMR_PATIENT_BL_NEW t where MZ_FLAG=‘#‘ ) select a.CNO from t a where a.BL_ORDNO=b.BL_ORDNO )
原文:https://www.cnblogs.com/CoreXin/p/14073487.html