SQL to find duplicate rows created within 5 seconds of each other

Hi,

We have a process that has created duplicate rows in a table where the records are identical except the creation date of the two records is approx 5 seconds apart.

I need an SQL query that will retrieve all the transaction_id's that have duplicates and were created within a few seconds of each other.

The query doesn't need to retreive both rows in question, just a single row with the transaction_id affected.

thanks in advance,

regards,

Andrew