select s_no,s_name,s_sex,s_age,s_dept from student where not exists (select 1 from (select s_name from student group by s_name having count(s_name)>1) awhere a.s_name=student.s_name)
语法有误，这样试试
