1.在select提取的每个结果前加上一序号列,从1开始,步长为 ...
select (select count(*) from blog A where A.id <=B.id) As UnID,* from blog B
2.Groupby order by top 的使用技巧
Code
1.在select提取的每个结果前加上一序号列,从1开始,步长为 ...
select (select count(*) from blog A where A.id <=B.id) As UnID,* from blog B
2.Groupby order by top 的使用技巧