SELECT * FROM adr_adressen WHERE (SELECT f_adr FROM adr_adressen GROUP BY f_adr HAVING count(f_adr) > 1 ORDER BY f_adr DESC LIMIT 1) = f_adr
Error Code : 1242 Subquery returns more than 1 row (0 ms taken)
SELECT * FROM adr_adressen WHERE f_adr in (SELECT f_adr FROM adr_adressen GROUP BY f_adr HAVING count(*) > 1)
SELECT * FROM adr_adressen WHERE f_adr in (SELECT f_adr FROM adr_adressen GROUP BY f_adr HAVING count(*) > 1) ORDER BY f_adr LIMIT 100
(100 row(s)returned) (367547 ms taken)
create index idx_f_adr on adr_adressen (f_adr) ;
(3261 row(s)returned) (115766 ms taken)
(100 row(s)returned) (172 ms taken)
58.4k Fragen
249k Antworten
7k Nutzer