select name,id from students where name in (select name from students group by name desc) group by name having count(name)>1
sonunda bende yaptım ama arkadaşdan count kısmını kopya cektim