MYSQL 求和排序方法 - V2EX

Home Sign Up Sign In

› MySQL 5.5 Community Server

› MySQL 5.6 Community Server

› Percona Configuration Wizard

› XtraBackup 搭建主从复制

Great Sites on MySQL

› MySQL Performance Blog

› Severalnines

推荐管理工具

推荐书目

› MySQL Cookbook

MySQL 相关项目

参考文档

› http://mysql-python.sourceforge.net/MySQLdb.html

This topic created in 4345 days ago, the information mentioned may be changed or developed.

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总和排序写法，。。

4 replies • 2014-06-28 09:37:47 +08:00

1

zac

Jun 28, 2014

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

2

crazybubble

Jun 28, 2014

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

3

Jack

OP

Jun 28, 2014

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

4

Jack

OP

Jun 28, 2014

@crazybubble seems working ! thx !

About · Help · Advertise · Blog · API · FAQ · Solana · 1361 Online Highest 6679 ·

Select Language

创意工作者们的社区

World is powered by solitude

VERSION: 3.9.8.5 · 36ms · UTC 17:13 · PVG 01:13 · LAX 10:13 · JFK 13:13
♥ Do have faith in what you're doing.