How to retrieve the latest created record for each id in a table?

you can you

ROW_NUMBER()  

function.

declare  @tbl table
(
	Id int,
	Name nvarchar(50),
	[STATUS] nvarchar(50),
	[DateTime] date
)

INSERT INTO @tbl(Id,Name,[STATUS],[DateTime])
VALUES
(1,  'x',     'not valid',  '2020-6-5'),
(2,  'y',     'valid',      '2020-3-1'),
(1,  'x',    'valid',      '2020-6-6')


declare  @tbl2 table
(
	Id int,
	Name nvarchar(50),
	[STATUS] nvarchar(50),
	[DateTime] date,
	RowNumber int
)

INSERT INTO @tbl2(Id,Name,[STATUS],[DateTime],RowNumber)
SELECT *,ROW_NUMBER()   over( partition by  Id order by [DateTime] desc) AS RowNumber  FROM @tbl


SELECT * FROM @tbl2 WHERE [@tbl2].RowNumber=1

output :

Id	Name	STATUS	DateTime	RowNumber
1	x	valid	2020-06-06	1
2	y	valid	2020-03-01	1

C'mon - you haven't even attempted to write SQL, you're getting us to do your homework or whatever for you....

So what would happen if you wrote

SELECT * from table;

well, clearly, thats gets everything, not what you asked for is it ? .. so how about

SELECT * from table where status != 'not valid';

Well, that's a bit closer , but you're not all the way there, you still need to think about the 'latest' record created - how are you going to handle that - are you going to test or look at the Datetime field ??

Why dont you have a go, and improve your question with what you've got, when you've really tried something and are stuck - we dont do homework for people