I have this scenario:

Published Provider Number Provider Name FYE
2009Q1 378282 John Hospital 9/30/2000
2008Q2 378282 John Hospital 9/30/2000
2007Q4 378282 John Hospital 9/30/2000
2007Q1 378282 John Hospital 9/30/2000
2006Q2 378282 John Hospital 9/30/2000
2009Q1 378282 John Hospital 9/30/2001
2008Q2 378282 John Hospital 9/30/2001

I have over 100,000 records with records like this. I would like to show just one record for each provider number and fiscal year end for the latest quarter.. How do I go about doing this? I want to show this:

2009Q1 378282 John Hospital 9/30/2000
2009Q1 378282 John Hospital 9/30/2001



Thanks in advance!!!