SQL Server does not support QUALIFY which appears in other databases such as Teradata. Here is one way to write your query in a similar way, ... ... <看更多>

Or is SQL Server optimized to select only the 5 records from the original Employee table too? DECLARE @Index INT; DECLARE @PageSize INT; SET @Index ... ... <看更多>