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