SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution | 馬達拉 - 點部落

2015-08-05

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

select * from [dbo].[YDD_RESOURCE_DESCRIPTION]

order by RESOURCE_ID

offset 0 rows

fetch next 10 rows only;