select top 2 * from tables order by date asc should get you there. Rob
On Tue, Nov 18, 2008 at 5:00 PM, Sung Woo <[EMAIL PROTECTED]> wrote: > There's probably a really simple answer to this. Here's the sample > dataset: > > id name date_due date_modified > 1 Woo 1/1/2009 11/18/2008 4:55PM > 1 Woo 2/1/2009 11/18/2008 4:57PM > 1 Woo 3/1/2009 11/18/2008 4:59PM > 2 Smith 1/1/2009 11/18/2008 5:02PM > 2 Smith 2/1/2009 11/18/2008 5:03PM > 2 Smith 3/1/2009 11/18/2008 5:04PM > > What SQL can I run to return the two latest records for each user? > > id name date_due date_modified > 1 Woo 3/1/2009 11/18/2008 4:59PM > 2 Smith 3/1/2009 11/18/2008 5:04PM > > SELECT id, name, date_due, date_modified > WHERE ????? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
