Reorder Results after Select within a Stored Procedure

I have a stored procedure that's doing a search and ranking the results using freetextable. This allows me to get the top X number most relevant results if I sort by the rank column. Works great.

Here's the problem, once I have those most relevant results, I then want to sort them by a date field. My end goal is to show the most relevant 50 results but show the most recent of those results first.

I tried nesting the whole thing in another select statement but I couldn't get that to work.

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.