I have a view that has each zipcode, dlrnum, zipdistance I need to find and store the zipcode, dlrnum based on the minimum distance.
I can find the minimum distance by zipcode but how do I get the dlrnum as well? I know there must be a way to use a sql to get this but am coming up blank. TIA Dan Goldberg
