SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table CommentTable (id int, SalesPerson varchar(100),
  Country varchar(100), Comment varchar(100),
  uplodaed_datetime datetime);
insert into CommentTable values (1,'John','USA','Comment A',GETDATE()-6);
insert into CommentTable values (2,'John','USA','Comment B',GETDATE()-5);
insert into CommentTable values (3,'John','UK','Comment C',GETDATE()-4);
insert into CommentTable values (4,'John','USA','Comment D',GETDATE()-3);
insert into CommentTable values (5,'Sam','AUS','Comment E',GETDATE()-2);
insert into CommentTable values (6,'Sam','AUS','Comment F',GETDATE()-1);
insert into CommentTable values (7,'Sam','AUS','Comment G',GETDATE());
7 rows affected

SELECT 
SalesPerson, Country, MAX(uplodaed_datetime)
FROM CommentTable
GROUP BY SalesPerson, Country;


SalesPerson
Country
(No column name)


Sam
AUS
2023-01-18 09:49:28.463

John
UK
2023-01-14 09:49:28.463

John
USA
2023-01-15 09:49:28.463


SELECT
c.id, c.SalesPerson, c.Country,
c.Comment, c.uplodaed_datetime
FROM 
CommentTable AS c
INNER JOIN 
(SELECT 
SalesPerson, Country, 
MAX(uplodaed_datetime) AS uplodaed_datetime
FROM CommentTable
GROUP BY SalesPerson, Country) AS sub
ON c.SalesPerson = sub.SalesPerson
AND c.Country = sub.Country
AND c.uplodaed_datetime = sub.uplodaed_datetime
ORDER BY c.id;


id
SalesPerson
Country
Comment
uplodaed_datetime


3
John
UK
Comment C
2023-01-14 09:49:28.463

4
John
USA
Comment D
2023-01-15 09:49:28.463

7
Sam
AUS
Comment G
2023-01-18 09:49:28.463

SalesPerson	Country	(No column name)
Sam	AUS	2023-01-18 09:49:28.463
John	UK	2023-01-14 09:49:28.463
John	USA	2023-01-15 09:49:28.463

id	SalesPerson	Country	Comment	uplodaed_datetime
3	John	UK	Comment C	2023-01-14 09:49:28.463
4	John	USA	Comment D	2023-01-15 09:49:28.463
7	Sam	AUS	Comment G	2023-01-18 09:49:28.463