-----Original Message-----
From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf
Of Igor Tandetnik
Sent: Thursday, December 13, 2018 12:16 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] Grouping guidance

> select Request from MyTable group by Request having count(distinct
> Description) = 2

Nice, I managed it with a join but this is far simpler.

Thanks!
jlc
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to