Paginated SQL statements for multi-table joins:

Paginated SQL statements for multi-table joins :

originally

Select Top page size a.aid from table 1 a LEFT JOIN table 2 B on a.aid=b.aid where A.aid not in (select Top page index * page size love from

Table 1 a LEFT JOIN table 2 B on a.aid=b.aid where condition) and condition;

after optimization

With C as (select Rn=row_number () over (order by x.id), * FROM (SELECT * FROM table 1 a LEFT JOIN table 2 b on A.aid=b.aid WH ere condition) x)

SELECT * from C where RN between (page index-1) * Page size + 1 and page index * Page size

Paginated SQL statements for multi-table joins: