1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| With MaTable (ID, C2, C3) as
(
select 1, convert(datetime, '01/01/1900', 103), 36 union all
select 2, convert(datetime, '27/08/2010', 103), 36 union all
select 3, convert(datetime, '05/08/2010', 103), 55 union all
select 4, convert(datetime, '01/01/1900', 103), 36 union all
select 5, convert(datetime, '10/06/2010', 103), 36 union all
select 6, convert(datetime, '01/07/2010', 103), 55
)
, sr (ID, C2, C3, rn) as
(
select ID, C2, C3,
row_number() over(partition by c3 order by c2 desc)
from MaTable
)
select ID, C2, C3
from sr
where rn = 1;
ID C2 C3
----------- ----------------------- -----------
2 2010-08-27 00:00:00.000 36
3 2010-08-05 00:00:00.000 55 |
Partager