SQL Help

[Bob Sneidar]

Even better!
 
Bob S


> On Jun 1, 2018, at 17:48 , Mike Bonner via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> if I understand correctly, and just off the top of my head, using "limit"
> is one way to do this...
> The sql pseudo code would be something like:  select * from yourtable order
> by iStoreGrp descending where meterNum = 1 AND valveNum = 3 limit 1
> This would grab all the rows, sort them by istoregrp and return the top
> entry
> 
> On Fri, Jun 1, 2018 at 6:31 PM, William Prothero via use-livecode <
> use-livecode at lists.runrev.com> 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