select t.*,
       row_number() over (partition by task_id order by col3) as position
from t
where task_id = 6 and status = 'ACTIVE';