SQLite 如何加序号
SQLite数据库 如何加序号
select rowid as xh,NUM as rownum,OrdersNum FROM PrintHistory where IsRemove='1'
and userName='15895875800' ORDER BY UpdateTime desc,Num DESC
XH NUM OrdersNum
4 4 20150424143737875
3 3 20150424105216484
2 2 20150420142231145
5 5 20150423143832073
6 6 20150423143947708
如何将XH变为1、2、3、4、5
用rowid 获取不对