Select data before and and after commit transaction number xxx

–Selects actual data state before commit transaction #35704
SET show_deleted_records = 1;
SELECT COUNT(*) cnt
FROM (SELECT CASE
WHEN MAX(CASE WHEN createxid < 35704 THEN createxid END)OVER(PARTITION BY rowid) = createxid
AND (MAX(deletexid)OVER(PARTITION BY rowid) >= 35704 OR deletexid = 0)
THEN 1
END is_current,
*
FROM mydb..customers c
) t1
WHERE is_current = 1;

SET show_deleted_records = 1;
–Selects actual data state after commit transaction #35704
SELECT COUNT(*) cnt
FROM (SELECT CASE
WHEN MAX(CASE WHEN createxid <= 35704 THEN createxid END)OVER(PARTITION BY rowid) = createxid
AND (MAX(deletexid)OVER(PARTITION BY rowid) > 35704 OR deletexid = 0)
THEN 1
END is_current,
*
FROM mydb..customers c
) t1
WHERE is_current = 1;