Min date for repeated values

Question

Hi Expert,
I wanted to fetch min date records where value column data is repeated

create table test3
(newdate datetime,status varchar(22),value varchar(22)
)
insert into test3
values

('2021-06-16 09:44:47.000', 'Newthree', '6 - 1'),
('2022-04-01 18:00:57.000', 'Newthree', '6 - 1'),
('2022-03-28 15:58:40.000', 'Newtwo', '3 - Test'),
('2022-03-31 15:20:17.000', 'Newtwo', '8 - MO'),
('2022-04-01 18:20:27.000', 'Newtwo', '8 - MO'),
('2022-03-28 12:48:46.000', 'Newone', '4 - Dead'),
('2022-04-01 18:20:28.000', 'Newone', '7 - Lost')

expected output
('2021-06-16 09:44:47.000', 'Newthree', '6 - 1')
('2022-03-28 15:58:40.000', 'Newtwo', '3 - Test')
('2022-03-31 15:20:17.000', 'Newtwo', '8 - MO'),
('2022-03-28 12:48:46.000', 'Newone', '4 - Dead'),
('2022-04-01 18:20:28.000', 'Newone', '7 - Lost')

Answer 1

Why do you continue to ask the same (or almost the same) question over and over?

;with cte as (select *, ROW_NUMBER() over (partition by [Status], [Value] ORDER BY NewDate) as Rn from dbo.Test)

select * from cte where Rn = 1 -- minimum datetime value for same status and value

Answer 2

Check this query too:

select min(newdate) as newdate, status, value
from test3
group by status, value
order by newdate

Answer 3

modified the query littlebit
;with cte as (select *, ROW_NUMBER() over (partition by status, [Value] ORDER BY NewDate) as Rn from dbo.Test3)

select * from cte where Rn = 1 -- minimum datetime value for same status and value