Here's the solutions that I finally arrived at...

Select State, Company, Revenue

FROM myTable A

WHERE Revenue IN

(

Select TOP 2 Revenue

From myTable B

WHERE B.State = A.State

Order by Revenue DESC

)

Order by State, Revenue DESC

Thanks for the help

Brian