https://blog.youkuaiyun.com/lavlyzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/lavly/article/details/4771471https://blog.youkuaiyun.com/lavly/article/details/4771471lavlyThu, 05 Nov 2009 13:46:00 +0800a.数量) as 排名 from 表名 a order by 数量 desc    select (select count(*)+1 as OrderTop from Tab_ProdTags b where b.CompeteMoney>a.CompeteMoney]]>https://blog.youkuaiyun.com/lavly/article/details/4737224https://blog.youkuaiyun.com/lavly/article/details/4737224lavlyWed, 28 Oct 2009 10:52:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4668367https://blog.youkuaiyun.com/lavly/article/details/4668367lavlyWed, 14 Oct 2009 11:07:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4656917https://blog.youkuaiyun.com/lavly/article/details/4656917lavlyMon, 12 Oct 2009 09:51:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4650119https://blog.youkuaiyun.com/lavly/article/details/4650119lavlySat, 10 Oct 2009 14:24:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4645114https://blog.youkuaiyun.com/lavly/article/details/4645114lavlyFri, 09 Oct 2009 11:35:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4606088https://blog.youkuaiyun.com/lavly/article/details/4606088lavlyMon, 28 Sep 2009 16:49:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4605196https://blog.youkuaiyun.com/lavly/article/details/4605196lavlyMon, 28 Sep 2009 15:12:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4551539https://blog.youkuaiyun.com/lavly/article/details/4551539lavlyMon, 14 Sep 2009 15:27:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4542338https://blog.youkuaiyun.com/lavly/article/details/4542338lavlyFri, 11 Sep 2009 13:13:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4534357https://blog.youkuaiyun.com/lavly/article/details/4534357lavlyWed, 09 Sep 2009 10:22:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4511981https://blog.youkuaiyun.com/lavly/article/details/4511981lavlyWed, 02 Sep 2009 16:34:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4493921https://blog.youkuaiyun.com/lavly/article/details/4493921lavlyFri, 28 Aug 2009 16:28:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4487740https://blog.youkuaiyun.com/lavly/article/details/4487740lavlyWed, 26 Aug 2009 19:37:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4443789https://blog.youkuaiyun.com/lavly/article/details/4443789lavlyThu, 13 Aug 2009 17:39:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4443787https://blog.youkuaiyun.com/lavly/article/details/4443787lavlyThu, 13 Aug 2009 17:38:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4443782https://blog.youkuaiyun.com/lavly/article/details/4443782lavlyThu, 13 Aug 2009 17:37:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4443770https://blog.youkuaiyun.com/lavly/article/details/4443770lavlyThu, 13 Aug 2009 17:36:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4443762https://blog.youkuaiyun.com/lavly/article/details/4443762lavlyThu, 13 Aug 2009 17:35:00 +0800https://blog.youkuaiyun.com/lavly/article/details/4441505https://blog.youkuaiyun.com/lavly/article/details/4441505lavlyThu, 13 Aug 2009 11:08:00 +0800