|
|
Posted by laptop on 03/31/06 11:07
Sorry, that should read "given that Strawberry's query...".
Confusing hunh?
"laptop" <laptopaliasathotmail.com> wrote in message
news:442ce251$0$668$fa0fcedb@news.zen.co.uk...
> What was Shaun's solution? I can't see it in the thread. I'm still a
> beginner with this stuff myself but, given that my query does seem to
> return the correct answer, why is it wrong?
>
> Cheers.
> "Stefan Rybacki" <stefan.rybacki@gmx.net> wrote in message
> news:493m5jFmnechU2@individual.net...
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> strawberry schrieb:
>>> I think this is right...
>>>
>>> SELECT propertyid, MAX( valuationdate ) , valuation
>>> FROM properties
>>> GROUP BY propertyid
>>>
>> That doesn't work because valuation is unpredictable and the fact that
>> mysql isn't throwing an error does not meant that this is a wrong query.
>>
>> So better use the solutions from Shaun. And I do even know another
>> solution for the case that there is no LIMIT or TOP available ;)
>>
>> Regards
>> Stefan
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.2.1 (MingW32)
>>
>> iD8DBQFELKK1yeCLzp/JKjARAt/RAJ4nWRAHQdqYVyvt8hprc7h9hhrXhgCgod9d
>> PIJ8wmI1cqXLaqB2oLPDXYs=
>> =9w+t
>> -----END PGP SIGNATURE-----
>
>
Navigation:
[Reply to this message]
|