加序号的SQL语句怎么写? - MS-SQL Server / 疑难问题

SELECT   fmonth,   SUM(sellQty)   AS   Expr1,from   tstockBLQ   GROUP   BY   fmonth   ORDER   BY   SUM(StockQty)

请帮忙把上面的语句完善一下,我要下面的结果,谢谢!

月份           销售总数       名次
200510 6204201         1
200512 3642942         2
200511 412976           3

---

2005可以，2000好像要用变量或临时表

---

SQL code:
select
*,名次=row_number()over(partition by 月份 order by Expr1 desc)
from
(SELECT fmonth, SUM(sellQty) AS Expr1,from tstockBLQ GROUP BY fmonth )t

---

SQL code:
--try
SELECT fmonth,
SUM(sellQty) AS Expr1,
(select count(*)from tstockBLQ where fmonth=t.fmonth and SUM(sellQty)>SUM(t.sellQty))
from tstockBLQ t
GROUP BY fmonth
ORDER BY SUM(StockQty)

---

引用

SQL code
--try
SELECT fmonth,
SUM(sellQty) AS Expr1,
(select count(*)from tstockBLQ where fmonth=t.fmonth and SUM(sellQty)>SUM(t.sellQty))
from tstockBLQ t
GROUP BY fmonth
ORDER……