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:315473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
