数据库联合查找

-- 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