Please try this one
SELECT T1.LISTID, T1.CREATEDDATE, T1.LISTTABLENAMEQ
FROM TABLE_1 T1
INNER JOIN (SELECT LISTID, MAX(CREATEDDATE)CREATEDDATE
FROM TABLE_1
GROUP BY LISTID) T2
ON DATEDIFF(DAY, T1.CREATEDDATE, T2.CREATEDDATE)=0 AND T1.LISTID = T2.LISTID