In case of paging with Table Record Aggregates fetching records according to line count from database but in case of advance sql it is fetching all records from database every time. In this demo I done the implementation so that advance sql is also fetching data as per line count of table record(same way Aggregates in case of paging). It will improve the performance of advance sql.