Having语句通常与Group By一起使用,用来过滤由Group By语句返回的结果集;
SELECT peopleId, seq FROM vitae GROUP BY peopleId, seq HAVING count(*) > 1
使其过滤的更加仔细!
Having语句通常与Group By一起使用,用来过滤由Group By语句返回的结果集;
SELECT peopleId, seq FROM vitae GROUP BY peopleId, seq HAVING count(*) > 1
使其过滤的更加仔细!