文章表:article主键 标题ID Title
题目:Title相同的记录只显示最新的一条
查询语句:sql = "select max(ID) from [article] group by Title"注释:以“Title”分组,查询出组内“ID”最大的记录
sqlStr = "select * from [article] where ID in ("&sql&")"注释:查询出“ID”在(N,N+1)内的记录
连接起来写法:sqlStr = "select * from [article] where ID in (select max(ID) from [article] group by Title)"