MYSQL 求和排序方法

[Jack]

s_ID s_title s_t s_date
1 subject1 20 2014-01-01
2 subject1 30 2014-02-01
3 subject2 40 2014-02-02
4 subject2 30 2014-02-03
5 subject3 90 2014-02-03
6 subject3 40 2014-02-05
7 subject1 30 2014-03-01

求2月份按每个subject的s_t总和排序写法，。。

[zac]

select sum (s_t) as count from 表 where 2月区间， order by s_ID DESC 满足需求么

[crazybubble]

SELECT s_title, sum(s_t) AS sum_s_t FROM xxxx WHERE s_date >= '2014-02-01' AND s_date <= '2014-02-28' GROUP BY s_title ORDER BY sum_s_t

[Jack]

@zac 这样并未按subject的s_t的总和排序，而且这么写只会返回一条结果

[Jack]

@crazybubble seems working ! thx !