Tag Archives: SQL

Best practices of implementing pagination for one-to-many results in SQL

Introduction One-to-many results paging is a prevalent scenario, for example, we want to query the product and product picture information. But many people will encounter the misunderstanding of paging here and get incorrect results. Come to analyze and solve this problem today. Problem analysis Let’s first create a simple commodity table and the corresponding commodity picture relationship table.… Read More »