RE: SELECT earliest unique records

2004-10-12 Thread Jay Blanchard
[snip] I have a table that contains a item_id field (non unique index) id field and a date field. How would you go about selecting rows from the table (single row for each item_id with the earliest date field for that item_id). If I use group by item_id the date field will be whatever the

Re: SELECT earliest unique records

2004-10-12 Thread Dan Sashko
: Jay Blanchard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 2:47 PM Subject: RE: SELECT earliest unique records [snip] I have a table that contains a item_id field (non unique index) id field and a date field. How would you go about selecting rows from the table (single row

Re: SELECT earliest unique records

2004-10-12 Thread Chris
it so that the entire row is the one that contains the earliest data field ? - Original Message - From: Jay Blanchard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 2:47 PM Subject: RE: SELECT earliest unique records [snip] I have a table that contains a item_id