Thanks.
- Original Message -
From: "Igor Tandetnik"
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" wrote
in message news:6a90e70a6
"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 I'm really after,
> howev
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 rows
3 matches
Mail list logo