Re: [sqlite] [EXTERNAL] Find key, value duplicates but with differing values

2018-10-12 Thread Dominique Devienne
On Thu, Oct 11, 2018 at 6:21 PM Hick Gunter 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 :)

Re: [sqlite] [EXTERNAL] Find key, value duplicates but with differing values

2018-10-11 Thread Hick Gunter
An: General Discussion of SQLite Database Betreff: [EXTERNAL] [sqlite] Find key,value duplicates but with differing values I can find duplicates fine: select xmd.partId, parts.title, xmd.name, count(*) "#dupplicates", group_concat(xmd.value) "values",