SQL Server中的一个奇怪问题

今天无意中看到了这个奇怪的问题，于是自己试了试，如下：

表：

SQL语句：

select top 2 * from (select top 4 * from [User]) as m order by UserId desc

select top 2 * from (select top 4 * from [User] order by UserId asc) as m order by UserId desc

结果：