Hi all I have a very long skinny table, 3 columns. A date, a patient number and test code. I want to extract the rows that are the most recent test code for each patient. If patient #3000 has had testcode # 80015 10 times over the last year, then I only want the most recent row for that testcode/patient combination
Is there a single command that can do that? Mike
