access select 10行数据出来,如何为这10行数据加上1到10的连续ID?
类似于 sql的rownumber
------解决方案--------------------
- SQL code
SELECT ( SELECT count(*) +1 FROM [Orders ] as a where a.[order id]<b.[order id]) AS myIndex, b.* FROM Orders AS b;
------解决方案--------------------
ROWNUM(伪行号)如何在ACCESS查询中实现。
http://blog.csdn.net/ACMAIN_CHM/archive/2010/01/03/5125291.aspx
------解决方案--------------------