Ahh, cool, thanks. :)
> S. Isaac Dealey wrote:
>>>SELECT CountryName, Value, Year
>>>FROM table
>>>WHERE
>>> (CountryName, Year) IN (
>>> SELECT CountryName, MAX(Year)
>>> FROM table
>>> GROUP BY CountryName
>>> )
>>
>>
>> Is that a sql92 standard IN clause?...
> I guess I had that comming :-)
> I don't know. It is however a SQL:1999 standard IN
> predicate:
> <quote>
> 8.4 <in predicate>
> Function
> Specify a quantified comparison.
> Format
> <in predicate> ::=
> <row value expression>
> [ NOT ] IN <in predicate value>
> <in predicate value> ::=
> <table subquery>
> | <left paren> <in value list> <right paren>
> <in value list> ::=
> <row value expression> { <comma> <row value
> expression> }...
> </quote> ISO-9075-2:1999
> 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
> This list and all House of Fusion resources hosted by
> CFHosting.com. The place for dependable ColdFusion
> Hosting.
> http://www.cfhosting.com
> Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
> ubscribe.cfm?user=633.558.4
s. isaac dealey 972-490-6624
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
