Hypothesis can never be proven. It can only be rejected with data contradicting it at hand.
"..the quickest way ..." implies someone else corrects you. ________________________________________ From: sqlite-users [[email protected]] on behalf of Don V Nielsen [[email protected]] Sent: Thursday, December 13, 2018 4:23 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Grouping guidance Two thumbs up on Igor. They say the quickest way to the correct answer is to post the wrong answer on the internet. Hypothesis just proven. On Thu, Dec 13, 2018 at 3:00 PM Igor Tandetnik <[email protected]> wrote: > On 12/13/2018 3:41 PM, Igor Tandetnik wrote: > > On 12/13/2018 3:27 PM, Don V Nielsen wrote: > >> Making a mountain out of a mole hill, but isn't the solution more > complex > >> that that? The description has to be Foo & Bar. But if given the > following, > >> then the simple answer dies. > > > > select Request from MyTable group by Request > > having sum(Description='Foo') > 0 and sum(Description='Bar') > 0; > > ... and sum(Description not in ['Foo', 'Bar']) = 0 > > Add conditions to taste. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > [email protected] > https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmailinglists.sqlite.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fsqlite-users&data=02%7C01%7Croman.fleysher%40einstein.yu.edu%7Ce637cb97a64741ad769808d6614148f0%7C04c70eb48f2648079934e02e89266ad0%7C1%7C0%7C636803330358231811&sdata=6j1x7YK3TEkbcyOpMGvLS3MXEj5jtJUtuU8CRvE%2FmhQ%3D&reserved=0 > _______________________________________________ sqlite-users mailing list [email protected] https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmailinglists.sqlite.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fsqlite-users&data=02%7C01%7Croman.fleysher%40einstein.yu.edu%7Ce637cb97a64741ad769808d6614148f0%7C04c70eb48f2648079934e02e89266ad0%7C1%7C0%7C636803330358231811&sdata=6j1x7YK3TEkbcyOpMGvLS3MXEj5jtJUtuU8CRvE%2FmhQ%3D&reserved=0 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
