Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select top 3 within a group
Message
 
 
À
19/12/2008 15:54:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01129690
Message ID:
01368998
Vues:
25
No, didn't test in VFP (don't have it installed locally). I guess it's too bad and it is not going to work in VFP.

>Naomi,
>
>did you test the statement? I get error "Invalid use of subquery"
>
>with :
>
>select  score , team ;
>	from crResult as A1 ;
>	where (select count(*) from crResult as A2 where A2.team=A1.team and A2.score<=A1.score ) <=2 ; 
>	order by score
>
>Regards,
>
>Koen
>
>P.S. My testdata consists of CREATE CURSOR crResult (team c(4), score n(2,0)) with values as per example given
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform