min / max 1

[foxup]

hi guys,

I have a country_rate.dbf with 2 fields (country, rate). Here is an example data:

country rate
1246 0.20
1246 0.23
1246 0.11
44 0.01
44 0.15
44 1.18
etc.

I would need the result to be:

country rate
1246 0.23
1246 0.11
44 0.01
44 1.18

Basically I need the MIN rate and the MAX rate for each dist "country". Please help.


Thanks,
FOXUP !

 

[Mike Lewis]

Try this:

[tt]SELECT Min(Rate) AS MinRate, Max(Rate) AS MaxRate, Country FROM Country_Rate GROUP BY Country[/tt]

I think that will do what you want.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[foxup]

awesome Mike. Thank you !!

 

[Olaf Doschke]

It's alright. It's all in a day's work for bicycle repair man.

Bye, Olaf.