Find duplicate records in oracle

Below is the sample query which can be used to find duplicate records in oracle . Also this query shows the way to implement having in Oracle.

select EMPID from TABLE1

where COMPANYID in (1024,1247)

 and group by EMPID

having count(*) > 1;