dense_rank() over (order by farm_fingerprint(cast(id as string)), id) as group_num from t;. Alternatively, a separate calculation by id ...
確定! 回上一頁