How to write sub-query with group by in Magento 1.9?

Question

I am new in learning Magento. I need to create query like this,

SELECT *
FROM YourTable
WHERE ARIDNR IN (
SELECT ARIDNR
FROM YourTable
GROUP BY ARIDNR
HAVING COUNT(*) > 1
)

How to write this using collection method or any other method?

Answer 1

Create Model that link with table YourTable.

$Collection = Mage::getModel('module/model')->getCollection();
$Collection->getSelect()->group('ARIDNR')->having('COUNT(*) > ?', 1);