Hugo Ahlenius wrote:
>
> I want to have a SELECT that gives me the highest values in a table
>
> The table looks like this:
> CountryName, Value, Year
Aren't value and year reserved words in SQL?
> And the data something like:
> Sweden, 80, 1970
> Sweden, 20, 1999
> Denmark, 10, 1962
> Denmark, 15, 1992
>
> (etc)
>
> What I want to get from the query is the rows:
> Sweden, 20, 1999
> Denmark, 15, 1992
SELECT CountryName, Value, Year
FROM table
WHERE
(CountryName, Year) IN (
SELECT CountryName, MAX(Year)
FROM table
GROUP BY CountryName
)
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
