不经常用经常忘记格式怎么写
SET @rownum = 0;
SELECT
@rownum:= @rownum+1 as rownum,
t_comment_task_org.comment_grade,
IFNULL(t_comment_task_org.comment_finish_count,0)AS comment_finish_count,
t_comment_task_org.comment_org_id
FROM
t_comment_task_org
WHERE
t_comment_task_org.comment_task_id = #{comment_task_id_}
ORDER BY
t_comment_task_org.comment_grade DESC