jalexm Posted August 28, 2014 Share Posted August 28, 2014 Hello,I have a table Tab1:Name Year Value-----------------------John 2010 1000Charles 2008 500Charles 2001 800John 2003 600Mary 2012 2500And need to get the following results:Name Year Value-----------------------Charles 2008 500John 2010 1000Mary 2012 2500As you can see, for each name I need to get the last record of the year.Does anyone know how to get this?Note: using MS-Access. Thanks. Link to comment Share on other sites More sharing options...
niche Posted August 29, 2014 Share Posted August 29, 2014 try this: http://stackoverflow.com/questions/16966415/sql-server-select-distinct-latest-values Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now