We don't sort tables. The entire relational world is based on the concept that absolutely no assumptions can ever be made on the physical order of...

Here's two other ways of doing it. First, write a query returning the rows you want to keep:

-- Query 1

select *

from #UserSession us

where us.LastUpdated...

Here's one way not using analytics or outer apply. At first I used a CTE but I removed that to use an inline view instead even though CTE's were not...