SQL ROW_NUMBER() OVER函数的基本用法

 

 

SELECT WaferID,SID,BagID+'-'+CONVERT( varchar, Row_Number() OVER (partition by BagID ORDER BY CONVERT(int, SID) asc)) as BagID FROM LMS_EPIStroeInfo

where BagID in ('G1-0020')