34,837
社区成员




SELECT * FROM biao a WHERE id in (SELECT max(id) FROM biao GROUP BY dd,lj HAVING COUNT(*)>1 )
SELECT * FROM biao a
WHERE exists(SELECT 1 FROM biao
where a.dd=dd and a.lj=lj
GROUP BY dd,lj HAVING COUNT(*)>1)
SELECT dd,lj FROM biao GROUP BY dd,lj HAVING COUNT(*)>1