比如一个表里只有contact字段
select Row_Number() OVER (ORDER BY v.contact desc) rank,v.contact from v_trade100000 v limit 100;
比如一个表里只有contact字段
select Row_Number() OVER (ORDER BY v.contact desc) rank,v.contact from v_trade100000 v limit 100;
转载于:https://www.cnblogs.com/canyangfeixue/p/6928389.html