SQL Help

[prothero at earthlearningsolutions.org]

Tnx for the input, folks. Yes, I want all of the columns. I could specify them each, because there are not many of them, but ......

I’m done for the evening, and will try your suggestions first thing in the morning. 

Best,
Bill

William Prothero
http://earthlearningsolutions.org

> On Jun 1, 2018, at 7:45 PM, Bob Sneidar via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> 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? 
> 
> Bob S
> 
> 
>> 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:
>>> 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
>> 
>> 
>> 
>> _______________________________________________
>> 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
> 
> _______________________________________________
> 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