select a.bugId from BugTrack a where delFlag='1' and exists(select 1 from BugTrack where bugId = a.bugId and delFlag='1' group by bugId having a.resolvedDate=max(resolvedDate))
select a.bugId from BugTrack a where delFlag='1' and not exists(select 1 from BugTrack where bugId = a.bugId and delFlag='1' and resolvedDate>a.resolvedDate)
这两个sql语句哪一个查询效率更高 数据非常多的情况下
select a.bugId from BugTrack a where delFlag='1' and not exists(select 1 from BugTrack where bugId = a.bugId and delFlag='1' and resolvedDate>a.resolvedDate)
这两个sql语句哪一个查询效率更高 数据非常多的情况下
