如何在SQL Server中使用rownumber获取匹配数据？

I am new to SQL Server and I don't know how to word this question. I have feeling this might be repeated. If you know it please flag it as duplicate. I will explain with data what I am trying to achieveI am new to SQL Server and I don't know how to