按照时间自动编号
select * from tb where ...
结果如下:
time num
9:01 23
9:02 1.2
9:03 112
9:04 3
... ..
希望得到如下结果:
id time num
1 9:01 23
2 9:02 1.2
3 9:03 112
4 9:04 3
5 ... ..
不用临时表.
[解决办法]
select *,(select count(*) from tb where a.time> =time ) from tb a where
[解决办法]
select (select count(1) from tb b where a.time> =b.time) as ID, * from tb a
