RedBirdOBX (10/4/2013)

---

This should be simple but I' having a hard time wrapping my head around this one late on a friday afternoon.

I have a table containing people and except for one or two fields, the entire record could be a duplicate and should be treated as so. For example:

FirstName, LastName, Address, City, State, SSN, SomeNumber

***************************************************

John, Doe, 123 Street, Atlanta, GA, 3000, 123456789, 001

John, Doe, 123 Street, Atlanta, GA, 3000, 123456789, 004

John, Doe, 123 Street, Atlanta, GA, 3000, 123456789, 007

How can I write a select statement to just get the most recently created record like:

John, Doe, 123 Street, Atlanta, GA, 3000, 123456789, 007

???