>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?
Edward's answer was right, but there's a different syntax, which I prefer.
SELECT * ;
FROM mytable ;
WHERE score IN (;
SELECTscore;
FROM mytable ;
GROUP BY score ;
HAVING COUNT(score) > 1)
I believe this will work....