Assuming pageoffset is required, the following result was found.
where ((Amount=0) and (Stage != 'Cancelled')) limit 2 offset 400"; // returns 2 deals after the first 400 records // OR v_PageOffset = v_Page - 1; v_PageOffset = v_PageOffset * v_PerPage; v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0)...