MotivateMan1394 (4/26/2015)
You could try something like this ...
Your Query Return Only One record
And My Query Return records equal the T1 Records Number.
First a minor terminology note. RDBs operates on sets of rows not records.The result of table expressions is a set of rows. Records are parts of recordsets returned by DB to applications.
LEFT JOIN i suppose.
with OrderedSet
as (
select ro = row_number() over (partition by code order by code asc, id desc)
,t2Id = t2.Id
,t2Code = t2.Code
from t2
)
select *
from t1
left join OrderedSet on t1.Id = OrderedSet.Id and OrderedSet.ro = 1;