sql查询添加序号

最新推荐文章于 2024-09-11 11:21:58 发布

QiGary

最新推荐文章于 2024-09-11 11:21:58 发布

阅读量167

点赞数

分类专栏：数据库文章标签： access

本文链接：https://blog.csdn.net/QiGary/article/details/89711542

版权

数据库专栏收录该内容

9 篇文章 0 订阅

订阅专栏

SELECT 
       (SELECT COUNT (*)
FROM   [T_Sick_Info] AS [t2]
WHERE  [t2].[sid] < [t1].[sid]) + (SELECT COUNT (*)
FROM   [T_Sick_Info] AS [t3]
WHERE  [t3].[sid] = [t1].[sid]
       AND [t3].[sid] < [t1].[sid]) + 1 AS [rowNum], 
       [sid], 
       [checkcode], 
       [recordtime]
FROM   [T_Sick_Info] [t1]
ORDER  BY [t1].[sid] ASC

查询结果如下，其中rowNum为目标序号值。