https://blog.youkuaiyun.com/newhuman66zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/newhuman66/article/details/6584090https://blog.youkuaiyun.com/newhuman66/article/details/6584090newhuman66Mon, 04 Jul 2011 17:50:49 +0800https://blog.youkuaiyun.com/newhuman66/article/details/6576983https://blog.youkuaiyun.com/newhuman66/article/details/6576983newhuman66Thu, 30 Jun 2011 13:46:00 +0800https://blog.youkuaiyun.com/newhuman66/article/details/6576930https://blog.youkuaiyun.com/newhuman66/article/details/6576930newhuman66Thu, 30 Jun 2011 13:19:00 +0800https://blog.youkuaiyun.com/newhuman66/article/details/6576752https://blog.youkuaiyun.com/newhuman66/article/details/6576752newhuman66Thu, 30 Jun 2011 11:36:00 +0800https://blog.youkuaiyun.com/newhuman66/article/details/6537719https://blog.youkuaiyun.com/newhuman66/article/details/6537719newhuman66Sat, 11 Jun 2011 10:19:00 +0800b.Num) as 排名  from 表 b   order by 要排名的字段（Num） desc两条关于生成排名的SQL语句: select name,score,(select count(*) from t where score>a.score)+1 from t a ]]>