mysql如何使用sql获取记录的行号

通过sql获取选中行的行号

select b.rownum from (SELECT (@i:=@i+1) rownum ,a.* FROM sxxmhq a , (SELECT @i:=0) as rownum   order by paixu desc )b