怎么写这个total的query# Database - 数据库
S*H
1 楼
用的是third party application. 所以一些standard SQL 支持的都不能用.
roll up 是没有的.怎么用一些basic sql 写.谢谢大家了.
TaskName TaskStatus TaskID
A open 1
A open 2
A Done 4
B pending 7
B done 99
expected results:
TaskName TaskStatus TaskID Total
A open 1
A open 2 2
A Done 4 1
B pending 7
B done 99 1
B pending 100 2
layout 不一定要这样. 但要一个 total , Group by TaskStatus,TaskName
还要list 出来每一个 TaskID.
roll up 是没有的.怎么用一些basic sql 写.谢谢大家了.
TaskName TaskStatus TaskID
A open 1
A open 2
A Done 4
B pending 7
B done 99
expected results:
TaskName TaskStatus TaskID Total
A open 1
A open 2 2
A Done 4 1
B pending 7
B done 99 1
B pending 100 2
layout 不一定要这样. 但要一个 total , Group by TaskStatus,TaskName
还要list 出来每一个 TaskID.