Re: [sqlite] Max Value In Group By Scenario

Thanks. - Original Message - From: "Igor Tandetnik" <itandet...@mvps.org> To: sqlite-users@sqlite.org Sent: Tuesday, May 5, 2009 8:05:42 AM GMT -05:00 US/Canada Eastern Subject: Re: [sqlite] Max Value In Group By Scenario "Eric Pankoke" <epank...@c

Re: [sqlite] Max Value In Group By Scenario

"Eric Pankoke" wrote in message news:6a90e70a6f404948991a0380e6793...@gamesmachine The following query: > > SELECT MfgProductID, ProductID, SUM(Weight) As MaxWeight FROM > dominantmaterials GROUP BY MfgProductID, ProductID > > Gets me most of the way to what I need. What

[sqlite] Max Value In Group By Scenario

I realize this is more of a general SQL question, but I figured while I was digging for the answer one of you would probably already know it. I have a table where the three import fields for my situation are MfgProductID, ProductID and Weight. For any given MfgProductID there can be multiple