Portál AbcLinuxu, 26. července 2025 04:35
select * from osoba where id in ( select id from osoba group by meno having count(id) > 1 );ked v takto dostenem vysledok skoro okamzite
create table tmp engine=memory select id from osoba group by meno having count(id) > 1; SELECT * FROM osoba where id in (select id from tmp); drop table tmp;
Řešení dotazu:
select a.* from osoba a join ( select id from osoba group by meno having count(id) > 1 ) b on a.id = b.id;
Tiskni
Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.