SQL Help

[Paul Dupuis]

Not tested, but:

SELECT max(iStoreGrp) FROM valveFlowsA WHERE meterNum =1 AND valveNum =3
GROUP BY meternum, valvenum, iStoreGrp

If my memory as I am falling asleep for the night serves me right.



On 6/1/2018 8:31 PM, William Prothero via use-livecode wrote:
> Folks:
> Maybe someone can answer this easily and save me some hair pulling. I know it’s google-able, but I’ve tried and know it’s going to be a trudge to get the right format.
>
> I want to make a query to a mySQL db that:
> The table is named: “valveFlowsA”
> I want the query to return the row with the maximum of a column named “iStoreGrp” when
> columns named “meterNum” and “valveNum” are specified. So, with meterNum =1 and
> valveNum =3, I would get the row for the maximum value of “iStoreGrp”.
>
> All of these columns are integers.
>
> If anybody has this query in their quiver of tools, please let me know.
> Thanks!
>
> Bill
>
> William A. Prothero
> http://earthlearningsolutions.org
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode