bobsneidar at iotecdigital.com
Fri Jun 1 22:45:23 EDT 2018
He wants all the columns I think. I suspect he will need a join on the same table. I'm too intoxicated to think about this, but I've done it before. Doesn't group by require that the columns be included in the select clause?
> On Jun 1, 2018, at 17:43 , Paul Dupuis via use-livecode <use-livecode at lists.runrev.com> wrote:
> 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:
>> 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.
>> William A. Prothero
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode