General information
Category:
Coding, syntax & commands
>>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....
This is so neat! Thank you.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only