数据库联合查找
来源:互联网 发布:网络销售包装美女身份 编辑:程序博客网 时间:2024/06/07 01:02
-- 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
- 数据库联合查找
- 数据库联合查找的sql语句
- 二分查找:联合中位数
- Excel 联合查找填充表格
- DB2联合数据库
- 【数据库】联合主键 删除
- 数据库--联合主键
- 数据库联合主键
- 数据库联合主键概念
- 数据库索引,联合索引
- 数据库的联合查询
- 数据库之联合索引
- 数据库联合查询的思考
- DB2 创建远程联合数据库
- 数据库联合查询的思考
- 关联数据库表多表联合查询
- 数据库索引:联合索引基本知识
- 《MySQL入门很简单》学习笔记(24)之自问自答(关键词:数据库/MySQL/外键/索引/联合查找/视图/触发器)
- WebService概述及案例分析
- Ubuntu14.04+caffe实现cifar10例程及单张图片测试
- 线程中run()和start()的区别
- webrtc音频限制带宽
- CodeForces 707CPythagorean Triples
- 数据库联合查找
- django post和get方法获取数据 数据在模板上的遍历
- nginx关键词
- java练习 扑克牌
- dispatch_async的简单使用要点
- ButterKnife 配置及使用
- python super()
- Windows下使用puTTY 和WinSCP 远程控制和管理Linux系统
- java中的值传递和引用传递问题