¼ÓÐòºÅµÄ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¡­¡­