Phân Trang.sql

declare @current_offset int = 0;
declare @current_increment int = 2;

SET @current_offset = @current_offset + @current_increment;

SELECT * FROM [Sinh Vien]
ORDER BY [Ten Sinh Vien]
OFFSET @current_offset rows
fetch next @current_increment ROWS ONLY;