SELECT WHERE IN help

[Tompkins Neil]

Hi

With a SELECT * FROM my_table WHERE record_id IN (3,4,5,6,7,3), how can I
return two records for the record_id 3 ?  Is it possible ?

Cheers
Neil