Information générale
Catégorie:
Codage, syntaxe et commandes
>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement