SELECT ( Row_Number() over( ORDER BY PathologyID )) AS RowNo,PathologyID,FrozenReportDr,FrozenExamineDr,FrozenCoincidence,FrozenReportTime from Pitaya_FrozenReport where 1=1 and FrozenReceiveDate BETWEEN '2019/1/5 0:00:00' and '2020/1/6 0:00:00' ORDER BY PathologyID
SQL SERVER查询结果添加行号
最新推荐文章于 2024-05-30 19:46:53 发布