ROW_NUMBER()over(orderbyGETDATE())asXh, SELECTFROM( SELECTsEmployeeNo,ROW_NUMBER()over(partitionbydbo.GetNoFromStr(sEmployeeNo) orderbydbo.GetNoFromStr(sEmployeeNo))asRowIndex, dbo.GetNoFromStr(sEmployeeNo)aa,sEmployeeNameCNFROMhrEmployee GROUPBYsEmployeeNo,sEmployeeNameCN )aWHERERowIndex>1