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
:)
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",
2 matches
Mail list logo