0 - 5 of 5 tags for row_number

How row_number function gets tie-breaker when there are the same value for diferent rows of the order by list?

SELECT a.col1
,CASE
WHEN b.cust_id IS NULL
THEN 0
ELSE 1
END AS is_true
FROM DB1.table1 AS a
LEFT JOIN DB2.table2 AS b
ON (
a.col3 = b.cust_id
AND a.start_date BETWEEN '2015-01-01' AND '2015-01-02'
) QUALIFY 1 = ROW_NUMBER() OVER (
PARTITION BY a.col1 ORDER BY b.col4

Hi All,
Greetings !

Good morning TD community,

Hi,

I am trying to find the PERSON_ID ranges by row count in a 27+ billion row table. This is so I can subset the data in smaller 'chunks' for processing.