使用row_number()增加序号
select row_number() over(ORDER BY srl), id, matcode,matId,matname,num,uom, srl
from C##PDMES.Bas_BomDet
where bomid='7F8E412288EE8586E055000000000001' and udf1='A'
结果:
使用row_number()增加序号
select row_number() over(ORDER BY srl), id, matcode,matId,matname,num,uom, srl
from C##PDMES.Bas_BomDet
where bomid='7F8E412288EE8586E055000000000001' and udf1='A'
结果: