Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select minimum
Message
 
 
To
11/06/2007 17:49:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01232093
Message ID:
01232129
Views:
11
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform