MYSQL 중복 체크한 쿼리

select distinct no,user_id,name,jumin,count(no) as kk from member group by jumin having kk !='1'