mysql查询不重复数据

1.查询不重复数据

select *, count(distinct name) from table group by name;

2.查询重复数据

select userid from table where userid in ( select userid from table group by userid having count(userid)>1);

sql:

SELECT 
	sa.id AS said,
	sa.CREATE_DATE,
	u.user_name AS '所属人',
	cus.qq AS 重复的QQ
FROM
	xxx.sale_airticket sa
LEFT JOIN xxx.sale_air_customer sac ON sac.SALE_AIRTICKET_ID = sa.id
LEFT JOIN xxx.customerr cus ON cus.id = sac.CUSTOMER_ID
LEFT JOIN xxx.busers u ON u.user_id = cus.USER_ID
WHERE
	cus.qq IN (
		SELECT
			qq
		FROM
			travel.customerr
		WHERE
			qq != ''
		GROUP BY
			qq
		HAVING
			Count(*) > 1
	)

GROUP BY sa.id HAVING COUNT(*) = 1

ORDER BY
	cus.qq