0 - 3 of 3 tags for quantile

Hi,
I have created below table
Employee
 emp_id    emp_sal
 1                10
 2                20
 3                30
 4                40
 5                50
 6                60
 
 
After executing
sel emp_id, emp_sal,quantile(6,emp_sal) as A from employee;

In my previous post i covered some ranking functions including SQL:2008 RANK, ROW_NUMBER & DENSE_RANK.

But Standard SQL defines three additional functions based on ranking:
PERCENT_RANK and CUME_DIST as relative rankings and a percentile calculation named NTILE.

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.