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/unsubscribe.cfm?user=89.70.4
