房天下

Fang.com
房天下 > 房天下问答 > 业主生活 > 其他

  • SQL数据汇总查询,高分

    表ask_info id 编号 bigint stu_name 姓名 varchar(20) stu_school 所在学校 varchar(50) state 信息状态 int 0 表示咨询中 1表示已报名 10 表示已上课)求SQL语句,显示出下表中的数据格式 优秀答案追加50分所在学校 咨询中 已报名 已上课 总计 -------------------------------------------------- ----------- 哈尔滨师范大学 0 2 1 3黑龙江大学 0 1 0 1总计 0 3 1 4

    提问者：h564335

    发布于2010-10-05

共1个回答
  • 小小生活网 丨Lv 2
    呵呵，少看了一行。select stu_school as '所在学校',(select count(*) from ask_info where stu_school=a.stu_school and state=0) as '咨询中',(select count(*) from ask_info where stu_school=a.stu_school and state=1) as '已报名',(select count(*) from ask_info where stu_school=a.stu_school and state=10) as '已上课',(select count(*) from ask_info where stu_school=a.stu_school) as '总计' from ask_info a group by stu_schoolunion select '总计',(select count(*) from ask_info where state=0) as '咨询中',(select count(*) from ask_info where state=1) as '已报名',(select count(*) from ask_info where state=10) as '已上课',(select count(*) from ask_info ) as '总计'
    +1 2010-10-06 举报
热门人气推荐
推荐楼盘小区二手房商圈租房热门知识 相关推荐房产百科
免责声明：问答内容均来源于互联网用户，房天下对其内容不负责任，如有版权或其他问题可以联系房天下进行删除。