MySQL
- 4 ответа
- 0 вопросов
4
Вклад в тег
SELECT COUNT(*)
FROM (
SELECT RIGHT(`phone`, 10) AS `p_number`, COUNT(*) AS `p_number_count`
FROM `contacts`
GROUP BY `p_number`
HAVING `p_number_count` > 1
) AS `dupl_p_numbers`
