SQL Help

Paul Dupuis paul at researchware.com
Sat Jun 2 07:46:46 EDT 2018


Sorry, I missed the all columns bit. Yes, LIMIT is the way to do this

SELECT * FROM valveFlowsA WHERE meterNum =1 AND valveNum =3
ORDER BY iStoreGrp DESC LIMIT 1

If you still need it. The DESC insure the record with the highest (max)
iStoreGrp value is returned first. CAUTION: If the data contained two
records with meterNum =1 AND valveNum =3 and the exact same iStoreGrp
value, I don't believe there is a way to predict which record will be
the first returned. This only works if iStoreGrp is effectively unique


On 6/1/2018 8:48 PM, Mike Bonner via use-livecode 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






More information about the Use-livecode mailing list