What seems so trivial, has been bugging me. I have a table with duplicate values on one column, while non-duplicate (date) values on the other. If I am to use DISTINCT it will only eliminate the row with the same date. But how do I use DISTINCT and only keep the ones with the oldest date?
I hope this does not come out as a dumb question. I have tried reviewing other posts to see if I could find my answer there but had no luck.
Any help would be greatly appreciated!
Student ModifiedDate John 06222015 John 06212015
What I would like is:
Student ModifiedDate John 06212015