SQL Help

beugelaar at solidit.nl beugelaar at solidit.nl
Mon Jun 4 01:47:47 EDT 2018


Group by




Get Outlook for Android







On Sun, Jun 3, 2018 at 7:45 PM +0200, "Bob Sneidar via use-livecode" <use-livecode at lists.runrev.com> wrote:










That will only return the maximum value, not the record itself. 

Bob S


> On Jun 1, 2018, at 20:01 , prothero--- via use-livecode  wrote:
> 
> I’m thinking something like:
> 
> Select max(“iStoreGrp”) from “valveFlowsA” where (“valveNum”=n1 AND “meterNum”=n2)
> 
> Then I have to sort out how to put the statement in a string that can be sent to php.
> 
> Does this seem reasonable? I’ll find out tomorrow.
> 
> Best,
> Bill
> 
> William Prothero

_______________________________________________
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







More information about the use-livecode mailing list