• You could probably use Ranking Functions but that does involve CTE, temp table or a table variable.