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...@comcast.net> 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, > however, is the ProductID for each MfgProductID that has the greatest > combined weight from all MfgProductID / ProductID rows. select m, p, (select sum(Weight) from dominantmaterials where MfgProductId=m and ProductID=p) w from (select m, (select ProductID from dominantmaterials where MfgProductId = m group by ProductID order by sum(Weight) desc limit 1) p from (select distinct MfgProductId m from dominantmaterials)); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
