DECLARE @PageNumber AS INT, @RowspPage AS INT SET @PageNumber = 1 SET @RowspPage = 20 SELECT * FROM base_model INNER JOIN sub_model ON base_model.CBMD_BASE_MDL_NUMBER = sub_model.CBMD_BASE_MDL_NUMBER WHERE( base_model.CBMD_BASE_MDL_NUMBER IN ( SELECT base_model_category.CBMD_BASE_MDL_NUMBER FROM base_model_category INNER JOIN sub_category ON base_model_category.MMCSC_SUB_CATEGORY_ID = sub_category.MMCSC_SUB_CATEGORY_ID AND base_model_category.DC_DIVISION_CODE = sub_category.DC_DIVISION_CODE WHERE (sub_category.MMCC_CATEGORY_ID = '301') AND (sub_category.MMCSC_SUB_CATEGORY_ID = '3002') AND (sub_category.DC_DIVISION_CODE = '1') )) ORDER BY (CAST(CAST(sub_model.LIST_PRICE AS float) AS INT))DESC OFFSET ((@PageNumber - 1) * @RowspPage ) ROWS FETCH NEXT (@PageNumber * @RowspPage) ROWS ONLY
Customer Care:
Call For Sales:
