按一列筛选,不显示重复行 & 统计重复记录

select distinct a from 表

 

Select an_user,Count(*) From Qlikreport where QuestionItem in  ('Neutral')   Group By an_user Having Count(*) > 1