Access SQL question - select highest item only for each

In Access, I have a table with IDs mapped to Email Addresses like this.
Table of email mapped to IDsI want to write a SQL query that lists unique Email Addresses, and the latest (sequentially highest) ID.
Thanks for your help.
hindersalivaAsked:
Who is Participating?
 
_agx_Connect With a Mentor Commented:
SELECT email, MAX(ID) AS LatestSequentialID
FROM   YourTable
GROUP BY email
0
 
hindersalivaAuthor Commented:
Perfect AGX! Thanks.
0
 
hindersalivaAuthor Commented:
Those who write SQL statements every day will always know this!
This is a great resource for those who encounter special situations occasionally.
Thanks Expert-Exchange.
0
 
_agx_Commented:
You're welcome :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.