比如一个表里只有contact字段
select Row_Number() OVER (ORDER BY v.contact desc) rank,v.contact from v_trade100000 v limit 100;
