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 'id' for a
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