SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution

摘要:SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution


EX:


select * from [dbo].[YDD_RESOURCE_DESCRIPTION] 
order by RESOURCE_ID 
offset 0 rows
fetch next 10 rows only;