Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select minimum
Message
 
 
À
11/06/2007 17:49:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01232093
Message ID:
01232129
Vues:
10
>Sergey and Naomi
>
>Both of your suggestions produced a result set that included all of the records from crs1.
>However with a slight change to Sergey's code I got what I needed. Thank you, both.
>
>
>SELECT cost, site_name ;
>FROM crs1 c1 ;
>WHERE cost = (SELECT Min(cost) FROM crs1 )
>

>

Don,

I think you're right, since you only need two fields: Site for Min cost. Both my and Sergey's suggestions would work if you need to pull out more fields. (I actually wrote my code based on some old code from Sergey).
If it's not broken, fix it until it is.


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

Click here to load this message in the networking platform