SQL Help

Mike Bonner 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
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



More information about the Use-livecode mailing list