SQL DISTINCT 语句

select DISTINCT qu_id,an_ok from kn_answer

需要qu_id 不能为重的

select DISTINCT qu_id ,sum(an_ok) from kn_answer group by quid

你qu_id不要重复，那么后边的an_ok如何处理呢？

select DISTINCT qu_id,an_ok from kn_answer GROUP BY QU_ID

select *, count(distinct qu_id) from kn_answer group by qu_id

你这样试试

搜索出来的结果是不是

3 0

9 0

这样没有重复的?