热门标签
更多>
搜索结果
查询Tags标签: machineName,共有 2条记录-
sql 相同列值统一编号、相同列值自动编号
select ROW_NUMBER() over(order by t1.new_machineName) as N自动编号, DENSE_RANK() over(order BY t1.new_machineName) AS N相同列值统一编号, ROW_NUMBER() over(partition by t1.new_machineName Order by t1.new_machineName ASC,t1.statuscode asc…
2021/9/6 19:09:09 人评论 次浏览 -
sql 相同列值统一编号、相同列值自动编号
select ROW_NUMBER() over(order by t1.new_machineName) as N自动编号, DENSE_RANK() over(order BY t1.new_machineName) AS N相同列值统一编号, ROW_NUMBER() over(partition by t1.new_machineName Order by t1.new_machineName ASC,t1.statuscode asc…
2021/9/6 19:09:09 人评论 次浏览