Posted by Erland Sommarskog on 10/19/36 11:33

Yannick Turgeon (vendredi5h@gmail.com) writes:
> Ok. Thanks to both of you.
>
> I think something like:
>
> SELECT a.data
> FROM #Test a
> WHERE a.type = 'A'
> GROUP BY a.type
> HAVING pid = MAX(pid)
>
> or even better:
>
> SELECT a.data
> FROM #Test a
> WHERE a.type = 'A'
> AND pid = MAX(pid)
>
> would be a good functionnality (with MAX or any other aggregate
> function) to add to transact/SQL or to SQL standard.

Maybe. If it clear what it means. Which in at least in the second
case is not at all clear. MAX(pid) in the entire #Test? MAX(pid) for
type = 'A' or what?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]