Group by having count 1. Функция count sql. select max sql. функция max в sql. as count sql.