如何仅选择表中的最新条目？

select p.projectName, t.ThingNamefrom projects pjoin projectThinglink l on l.projectId = p.projectIdjoin thing t on t.thingId = l.thingIdwhere l.createdDate =( select max(l2.createdDate)  from projectThinglink l2  where l2.thingId = l.thingId);

注意：评论后已更正