# id唯一,num連續(xù)序號(hào)
# select a.id,num=(select count(1) from tb b where b.id<=a.id ) from tb a