mysql 显示 分组后序号

SET @prev_col1 = '';
SET @row_num = 0;
 
SELECT *
FROM (
  SELECT *, 
    CASE
      WHEN @prev_col1 = dept_code THEN @row_num := @row_num + 1
      ELSE @row_num := 1
    END AS row_num,
    @prev_col1 := dept_code
  FROM sys_task_do where created_time  >= '2024-08-05 11:01:57' and created_time <=  '2024-08-05 11:02:30' order by dept_code
) t
where t.row_num in (2,3)