* Ciprian Trofin
> I have 2 tables: currencies and quotes
>
> currencies
> ==
> id currency
> -
>
> quotes
> ==
> id date id_currency value
> ---
> Index (date, id_currency - UNIQUE)
>
>
> In order to find the most recent value for a
Add LIMIT x,y (x is first row and y the number of rows 1.e. 1,1 for
first row) at the end of the SQL and order the SQL. Not sure if this
helps, just initial thoughts.
On Wed, 2003-10-08 at 13:04, Ciprian Trofin wrote:
> I have 2 tables: currencies and quotes
>
> currencies
> ==
> id cu
I have 2 tables: currencies and quotes
currencies
==
id currency
-
quotes
==
id date id_currency value
---
Index (date, id_currency - UNIQUE)
In order to find the most recent value for a currency I use the following
logic:
1. SELECT m
