如何使用top子句复制SQL Server中的mysql范围和限制

I've been trying to replicate the limit and range feature provided in MySql in SQL Server with no luck as of yet. I have found several guides and now think my sql code is nearly correct but I'm still getting an error posted below.I've been trying to replicate the limit and ran