Posted by Alexander Kuznetsov on 10/02/96 11:51

Modifying Erland's query a little bit, on SQL 2005 only (untested):

SELECT t.pno, t.bno, t.status, t.build_date
FROM (
SELECT a.pno, a.bno, a.status, a.build_date,
row_number() over(partition by pno, bno order by build_date desc) rn
from
progress a
) t
where rn = 1

• Next in forum: SQLserver on SBS2003 returns old data
• Prev in forum: Re: constraint expression for unique keys
• Thread view: Re: how/what should be the query for this result

[Reply to this message]