On Thu, Oct 11, 2018 at 6:21 PM Hick Gunter <h...@scigames.at> wrote:
> Two nested selects > The inner select groups by partId, name, value > The outer select groups by partId, name > Thank you who replied, Gunter, Ryan, Roman, David. This was simpler than I thought. I should have reflected a bit more myself :) --DD create view qc$xdata_duplicate_names as > > select xdata.partId, parts.title, xdata.name, > > count(*) "#duplicates", > > group_concat(xdata.value) "values", > > group_concat(xdata.idx) "indexes" > > from xdata > > join parts on parts.id = xdata.partId > > group by partId, name > > having "#duplicates" > 1 > > >> create view qc$xdata_dups_diff_value as >> > select xdata.partId, parts.title, xdata.name, > > count(*) "#duplicates", > > group_concat(xdata.value) "values", > > group_concat(xdata.idx) "indexes" > > from ( > > select * > > from xdata > > group by partId, name, value > > ) xdata > > join parts on parts.id = xdata.partId > > group by xdata.partId, xdata.name > > having "#duplicates" > 1 > > > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users