I need some help with a very simple SQL query. I've not written any queries in a very long time and need to knock off some rust.
I have a table with a client id field and a servicedate field. Often times there can be multiple servicedates for a specific client. I simply want to return the first (oldest) servicedate for the unique client. Please provide quick snipet.
Any help is appreciated.