>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

Probably I misunderstand you but why you could not run command:
SELECT * from mytable where Score=nScore