表结构Field Type Collation Null Key Default
------------------ ------------ -------------- ------ ------ -------
id int(11) (NULL) NO PRI (NULL)
PROJECTID varchar(50) gbk_chinese_ci YES (NULL)
USERID varchar(50) gbk_chinese_ci YES (NULL) select,insert,update,references
USERNAME varchar(50) gbk_chinese_ci YES (NULL) select,insert,update,references
a1 int(11) (NULL) YES 0 select,insert,update,references
a2 int(11) (NULL) YES 0 select,insert,update,references
a3 int(11) (NULL) YES 0 select,insert,update,references
a4 int(11) (NULL) YES 0 select,insert,update,references
a5 int(11) (NULL) YES 0 select,insert,update,references
a6 int(11) (NULL) YES 0 select,insert,update,references
a7 int(11) (NULL) YES 0 select,insert,update,references
a8 int(11) (NULL) YES 0 select,insert,update,references
1 1 10001 教师1 10 10 2 0 0 0 3 8
2 1 10002 教师2 10 1 2 0 13 0 34 6
3 1 10003 教师3 10 12 2 0 30 3 12 4
4 1 10004 教师4 11 0 12 0 21 0 21 8
1条sql语句可以统计出合计值吗?
比如说
教师 4
a1 41
a2 23
a3 18
....
18 26
------------------ ------------ -------------- ------ ------ -------
id int(11) (NULL) NO PRI (NULL)
PROJECTID varchar(50) gbk_chinese_ci YES (NULL)
USERID varchar(50) gbk_chinese_ci YES (NULL) select,insert,update,references
USERNAME varchar(50) gbk_chinese_ci YES (NULL) select,insert,update,references
a1 int(11) (NULL) YES 0 select,insert,update,references
a2 int(11) (NULL) YES 0 select,insert,update,references
a3 int(11) (NULL) YES 0 select,insert,update,references
a4 int(11) (NULL) YES 0 select,insert,update,references
a5 int(11) (NULL) YES 0 select,insert,update,references
a6 int(11) (NULL) YES 0 select,insert,update,references
a7 int(11) (NULL) YES 0 select,insert,update,references
a8 int(11) (NULL) YES 0 select,insert,update,references
1 1 10001 教师1 10 10 2 0 0 0 3 8
2 1 10002 教师2 10 1 2 0 13 0 34 6
3 1 10003 教师3 10 12 2 0 30 3 12 4
4 1 10004 教师4 11 0 12 0 21 0 21 8
1条sql语句可以统计出合计值吗?
比如说
教师 4
a1 41
a2 23
a3 18
....
18 26
解决方案 »
- mysql中show tables能起别名吗
- 一個關於Mysql建立Foreign Key的問題
- mysql Error Nr. 2003 师傅们帮忙!
- 如何通过字符串建立分区
- 这个是 DeDeCMS 5.0 的TAG索引表, 能告诉这里详细字段的意思吗?还有它们的关系?
- 请教如何提高大量数据插入MYSQL数据库的效率~~急急急~~~~~~~~~~~~~~~
- 求一句查询语句,我想了半天想不出来,都失眠了?
- 如何改变MYSQL的默认端品3306?
- 出现这样的错误是怎么回事:无法定位程序输入点 mysql_real_escape_string于动态链接库libmysql.dll上。
- update 更新时需要查询本表,sql语句怎么写
- mysql不能正常显示中文 已设置为utf8
- 使用mysqlimport导入数据 如何覆盖已存在的
select a1,'a1' as mc from tt
union all
select a2,'a2' as mc from tt
union all
select a3,'a3' as mc from tt
union all
select a4,'a4' as mc from tt) a group by mc
select count(distinct USERNAME) as 教师数,
sum(a1) as a1_sum,
sum(a2) as a2_sum,
sum(a3) as a3_sum,
sum(a4) as a4_sum,
sum(a5) as a5_sum,
sum(a6) as a6_sum,
sum(a7) as a7_sum,
sum(a8) as a8_sum from tb_name
group by USERNAME