使用关键字rownum; 如:select rownum,s.* from winf_sv_ex_hybs_sxclgc s where s.sxbm=’441600782965164024000′ order by s.xh; 即可;