Чем заменить top 1 в запросе - MySQL

SELECT nazvanie, tarif 
FROM operator_svyazy, podklychenye 
WHERE operator_svyazy.id_operatora=podklychenye.id_operatora 
GROUP BY tarif, nazvanie, idОператора 
HAVING tarif IN (SELECT top 1 tarif 
FROM podklychenye t 
WHERE t.id_operatora=podklychenye.id_operatora 
GROUP BY id_operatora, tarif 
ORDER BY COUNT(*) DESC) 
ORDER BY nazvanie, tarif