27,580
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM DD AS A WHERE NOT EXISTS(SELECT 1 FROM DD WHERE (RID=A.RID AND SID=A.SID OR SID=A.RID AND RID=A.SID) AND DATA>A.DATA ) AND 1 IN(SID,RID)
这样改看看结果对不,同一个联系人和被联系人取最后一条记录SELECT * FROM DD AS A WHERE NOT EXISTS(SELECT 2 FROM DD WHERE RID=A.RID AND DATA>A.DATA ) AND 2 IN(SID,RID)
少了一条,能否再改下??谢谢了[/quote]
测测看是不是这样效果
SELECT * FROM DD AS A WHERE NOT EXISTS(SELECT 1 FROM DD WHERE (RID IN(A.RID,A.SID) OR SID IN(A.RID,A.SID)) AND DATA>A.DATA ) AND 2 IN(SID,RID)
SELECT * FROM DD AS A WHERE NOT EXISTS(SELECT 2 FROM DD WHERE RID=A.RID AND DATA>A.DATA ) AND 2 IN(SID,RID)
少了一条,能否再改下??谢谢了SELECT * FROM DD AS A WHERE NOT EXISTS(SELECT 1 FROM DD WHERE RID=A.RID AND (DATA>A.DATA OR DATA=A.DATA AND ID>a.ID))
SELECT sna,nei,data FROM dd a
WHERE NOT EXISTS(SELECT * FROM dd WHERE a.rid = rid AND data > a.data) and rid in (2,3,4)
SELECT * FROM dd a
WHERE NOT EXISTS(SELECT * FROM dd WHERE a.rid = rid AND data > a.data)