|
Posted by Yannick Turgeon on 10/22/83 11:33
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.
Yannick
Navigation:
[Reply to this message]
|