select no=(select count(t.di_id) from dwe_info t where t.di_id<=o.di_id ),* from dwe_info o 转载于:https://www.cnblogs.com/T_98Dsky/archive/2005/04/28/146792.html