count计算不重复的记录
SELECT COUNT( DISTINCT player_id ) FROM task;
返回记录不同的id
SELECT DISTINCT player_id FROM task;
同时作用于两列
SELECT DISTINCT player_id, task_id FROM task;
distinct关键字用法
最新推荐文章于 2024-09-03 15:36:32 发布
count计算不重复的记录
SELECT COUNT( DISTINCT player_id ) FROM task;
返回记录不同的id
SELECT DISTINCT player_id FROM task;
同时作用于两列
SELECT DISTINCT player_id, task_id FROM task;