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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode