当前位置: 代码迷 >> Sql Server >> 给SQL查询结果加上索引号解决方法
  详细解决方案

给SQL查询结果加上索引号解决方法

热度:81   发布时间:2016-04-24 09:54:19.0
给SQL查询结果加上索引号
现有表A的部分查询结果如下:
[BOMID]                      [工艺代码]                [排序字段]                                  [ID]
99055                         1                              7                                                529764
99055                         2                              13                                              529405
99055                         4                              34                                              539216
99055                         4                              43                                              535986
99055                         4                              67                                              502340
99055                         8                              70                                              536332
99055                         7                              82                                              539217
99055                         9                              94                                              537687
99055                         4                              97                                              537688
  相关解决方案