distinct关键字用法

count计算不重复的记录
SELECT COUNT( DISTINCT player_id ) FROM task;

返回记录不同的id
SELECT DISTINCT player_id FROM task;

同时作用于两列
SELECT DISTINCT player_id, task_id FROM task;