一些SQL语句，免得忘记

查询一列里不同类别的数量

SELECT 
 MAX(CASE NAME WHEN 'JX' THEN a.num ELSE 0 END ) 'JX',
 MAX(CASE NAME WHEN 'SG' THEN a.num ELSE 0 END ) 'SG',
 MAX(CASE NAME WHEN 'CS' THEN a.num ELSE 0 END ) 'CS'
FROM (
	SELECT 'JX' NAME ,COUNT(*)NUM FROM QingXi qx WHERE 1=1 AND qx.QX_Isvisble='0'
	UNION ALL
	SELECT 'SG' NAME ,COUNT(*)NUM FROM QingXi qx WHERE 1=1 AND qx.QX_Isvisble='1'
	UNION ALL
	SELECT 'CS' NAME ,COUNT(*)NUM FROM QingXi qx WHERE 1=1 AND qx.QX_Isvisble='2'
)a

带查询的插入语句

INSERT INTO yq_group
(gaccount,gnick,gtrends,gmanager,gcount)
(
	SELECT
	'77','88','99','66', bbuddy
	 FROM yq_buddy WHERE baccount='111'
)