SerialNo int ,

Time_Stamp varchar(255),

Status varchar(15));

insert into tbl values

(1548,'06/27/2022 12:30 pm','Success'),

(1543,'06/27/2022 12:32 pm','Success'),

(1432,'06/27/2022 12:33 pm','Success'),

(1511,'06/27/2022 12:34 pm','Success'),

(1511,'06/27/2022 12:45 pm','Success'),

(1511,'06/27/2022 12:48 pm','Success'),

(1000,'06/27/2022 12:50 pm','Success'),

(1549,'06/27/2022 12:51 pm','Success'),

(1435,'06/27/2022 12:52 pm','Success'),

(1435,'06/27/2022 12:53 pm','Success');

select SerialNo,Time_Stamp,row_number() over(partition by SerialNo order by str_to_date(Time_Stamp,"%m/%d/%Y %l:%i %p") desc ) as row_num

from tbl

) select * from cte;

FROM tbl t1

INNER JOIN ( select SerialNo,

Time_Stamp,

row_number() over(partition by SerialNo order by str_to_date(Time_Stamp,"%m/%d/%Y %l:%i %p") desc ) as row_num

from tbl

) as t2 on t1.SerialNo=t2.SerialNo and t1.Time_Stamp=t2.Time_Stamp

WHERE t2.row_num > 1;