数据库联合查找

-- SELECT * FROM t_videoTalkRecord;


-- SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT  max(id) 
--  FROM  t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND 
-- currentLoginUserId = '9999' AND recordType = 3 ORDER BY currentRecordSaveTimeStamp DESC;




-- SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 3 ORDER BY currentRecordSaveTimeStamp DESC;


-- SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 3;


-- SELECT * FROM t_videoTalkRecord WHERE userId IN(SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 3);


-- SELECT  max(id)  FROM  
-- t_videoTalkRecord  WHERE currentLoginUserId = '9999' GROUP BY userId  HAVING count(*) >= 1
-- 
-- SELECT  *  FROM  
-- t_videoTalkRecord  WHERE currentLoginUserId = '9999' AND recordType = 2 GROUP BY userId  HAVING count(*) >= 1




-- SELECT max(id) FROM  
-- t_videoTalkRecord  WHERE currentLoginUserId = '9999' AND recordType = 2 GROUP BY userId  HAVING count(*) >= 1


-- //查找去过重的未接记录
-- SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT max(id) FROM  
-- t_videoTalkRecord  WHERE currentLoginUserId = '9999' AND recordType = 2 GROUP BY userId  HAVING count(*) >= 1) AND 
-- currentLoginUserId = '9999' AND recordType = 2 ORDER BY currentRecordSaveTimeStamp DESC;


-- //好友关系去除重复
-- SELECT max(id) FROM  
-- t_videoTalkRecord  WHERE currentLoginUserId = '9999' AND recordType = 3 GROUP BY userId  HAVING count(*) >= 1
-- 
-- //查找好友去除重复 - 好友userid
-- SELECT userId FROM t_videoTalkRecord WHERE id IN (SELECT max(id) FROM  
-- t_videoTalkRecord  WHERE currentLoginUserId = '9999' AND recordType = 3 GROUP BY userId  HAVING count(*) >= 1) AND 
-- currentLoginUserId = '9999' AND recordType = 3;


-- //查找未接记录已经去重未接重复记录 并且 去除 非好友未接记录
-- SELECT * FROM (SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT max(id) FROM  
-- t_videoTalkRecord  WHERE currentLoginUserId = '9999' AND recordType = 2 GROUP BY userId  HAVING count(*) >= 1) AND 
-- currentLoginUserId = '9999' AND recordType = 2) WHERE userId IN(SELECT userId FROM t_videoTalkRecord WHERE id IN (SELECT max(id) FROM  
-- t_videoTalkRecord  WHERE currentLoginUserId = '9999' AND recordType = 3 GROUP BY userId  HAVING count(*) >= 1) AND 
-- currentLoginUserId = '9999' AND recordType = 3);


-- //查找好友已经去重好友重复记录
SELECT * FROM (SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT max(id) FROM  
t_videoTalkRecord  WHERE currentLoginUserId = '9999' AND recordType = 3 GROUP BY userId  HAVING count(*) >= 1) AND 
currentLoginUserId = '9999' AND recordType = 3) WHERE userId IN(SELECT userId FROM t_videoTalkRecord WHERE id IN (SELECT max(id) FROM  
t_videoTalkRecord  WHERE currentLoginUserId = '9999' AND recordType = 3 GROUP BY userId  HAVING count(*) >= 1) AND 
currentLoginUserId = '9999' AND recordType = 3) ORDER BY currentRecordSaveTimeStamp DESC;




-- SELECT * FROM t_videoTalkRecord WHERE id IN () AND 
-- currentLoginUserId = '9999' AND recordType = 2 ORDER BY currentRecordSaveTimeStamp DESC;






-- SELECT * FROM t_videoTalkRecord WHERE currentLoginUserId = '9999' AND recordType = 2;


-- SELECT userId FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 2;


-- SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1


-- SELECT userId FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 3


-- SELECT * FROM t_videoTalkRecord WHERE userId IN (SELECT userId FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 3);


-- SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- (SELECT * FROM t_videoTalkRecord WHERE userId IN (SELECT userId FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 2))  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 3 ORDER BY currentRecordSaveTimeStamp DESC;




-- SELECT * FROM t_videoTalkRecord WHERE userId IN(SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 3 ORDER BY currentRecordSaveTimeStamp DESC);


-- SELECT * FROM t_videoTalkRecord WHERE userId IN (SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1));


-- SELECT * FROM t_videoTalkRecord WHERE id IN (SELECT  max(id)  FROM  
-- t_videoTalkRecord  GROUP BY userId  HAVING count(*) >= 1) AND currentLoginUserId = '9999' 
-- AND recordType = 3