|
|
Posted by s on 03/30/06 08:56
On Tue, 28 Mar 2006 14:33:00 +0800, "McHenry" <mchenry@mchenry.com>
wrote:
>I have a table with 3 columns, propertyid, valuationdate & valuation
>
>I want to return the most recent valuation for each property, sounds simple
>but it's not !!
Not knowing what SQL engine you're using or how your table is defined,
try:
MySQL:
SELECT valuation FROM table WHERE propertyid = 123 ORDER BY
valuationdate DESC LIMIT 1
MSSQL et al:
SELECT TOP 1 valuation FROM table WHERE propertyid = 123 ORDER BY
valuationdate DESC
...hth
--
<s@guerril.la.ape> (to email, remove .ape)
--
Navigation:
[Reply to this message]
|