blob: 62b4c30e38278de67bfaf64cd457bb41ff373ffb [file]
SELECT DISTINCT a, COUNT(*) FROM t GROUP BY a HAVING COUNT(*) > 1 AND SUM(b) IS NOT NULL