I have a table where I have a numeric field with scores stored in them. I would like to select all the records with similar scores into a temp table in order to resolve other things.. I have tried select *,count(*)as tie from mytable group by tie > 1. But I cannot get it to list everyone. How can I do this?

TIA,

Jamuna