Help with RR SQL version 9

[Greenkat5]

Please could someone help me i need to find all the duplicate accident numbers in the report. The SQL is shown below.__The database is connected by Oracle ODBC____select__ CASSACCI."ACCIDENTNUMBER", CASSACCI."ACCIDENTDATE", CASSACIN."ACCIDENTNUMBER", CASSACIN."FORENAMES", CASSACIN."CONTACTTELNUMBER", CASSACIN."SURNAME", CASSACIN."OHSEENBY_ACCIDENT"__ from __CASS.CASSACCIDENTS CASSACCI, CASS.CASSACCIDENTINJURY_VIEW CASSACIN __where__CASSACIN."PIN" <> ^1^__order by__ CASSACIN."OHSEENBY_ACCIDENT"____Thanks in advance i^m waiting for my SQL training!!____Martin