SQL。SELECT (@i：=@i+1) i，user_id，user_name FROM `dt_user_all_orders`.(SELECT @i：=0) as i WHERE user_name=&#39；qqqqqqqqqq&#39；LIMIT 0，10；。结果。如果需要分组后再进行序号显示。SELECT drug_productor，@y：=@y+1 as num FROM( SELECT drug_productor FROM ts_drug a GROUP BY drug_productor) c，(SELECT @y：=0) d。结果。分析。