bonnmike at gmail.com
Fri Jun 1 20:48:33 EDT 2018
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
On Fri, Jun 1, 2018 at 6:31 PM, William Prothero via use-livecode <
use-livecode at lists.runrev.com> 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:
More information about the use-livecode