MySql 查询记录

单表查询院系下专业下的已就业人数

设计表

sql语句

SELECT info.SZYX,info.ZY,
	(SELECT count(*) FROM report_jy WHERE SZYX = info.SZYX
		AND ZY = info.ZY
		AND JYZK = '已就业'
	) yjys,
	(SELECT count(*) FROM report_jy WHERE SZYX = info.SZYX
		AND ZY = info.ZY AND JYZK = '未就业'
	) wjys,
	(SELECT count(*) FROM report_jy
		WHERE SZYX = info.SZYX
		AND ZY = info.ZY
		AND JYZK = '升学'
	) sxs
FROM report_jy AS info
WHERE (zy is not NULL AND zy !='')
GROUP BY ZY

 

内连接：INNER JOIN 

内连接INNER JOIN是最常用的连接操作。从数学的角度讲就是求两个表的交集，从笛卡