alternative for row_number function

Database

alternative for row_number function

Hi All,
Is there a less expensive way to implement the following

SELECT
COL_A,
COL_B
FROM
TABLE_A
QUALIFY ROW_NUMBER ( ) OVER (PARTITION BY COL_A,COL_C ORDER BY COL_A,COL_C, ASC ) < N;

(N is a number, and table_A has 2 billion rows, All columns are integers)

Thanks,
VM