Hello.
On Mon, Jul 16, 2001 at 05:51:34PM -0700, [EMAIL PROTECTED] wrote:
> Question:
>
> given data in a table such as
>
> id, value, date
> 0, value1, 1999-01-25
> 1, value2, 1999-01-02
> 2, value2, 1999-01-04
> 3, value1, 1999-01-22
> 4, value2, 2000-01-01
>
> how can i select the latest 'i
Question:
given data in a table such as
id, value, date
0, value1, 1999-01-25
1, value2, 1999-01-02
2, value2, 1999-01-04
3, value1, 1999-01-22
4, value2, 2000-01-01
how can i select the latest 'id' for a given same set of 'value' based on
'date'? ie: i would like to be able to get records id
