摘要: SELECT author_id, author_name, substring_index( group_concat( DISTINCT task_id ORDER BY task_id ASC ), ',', 3 ) AS taskList FROM author_info GROUP BY 阅读全文