-
- XRYY 2025-10-09
2-2 [MySQL] 如何在子查询中实现多列过滤
select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id = b.user_id join (select user_id,max(kills) as cnt from user_kills group by user_id) c on b.user_id = c.user_id and b.kill=c.cnt;
- 0赞 · 0采集
-
- 斜杠男人 2021-02-25
mysql中独有的多列过滤方式（大于1列）
备注：子查询效率低，最好还是使用连接查询
-
截图0赞 · 1采集
-
- 斜杠男人 2021-02-25
在子查询中实现多列过滤
-
截图0赞 · 0采集
-
- 大大大大航 2020-12-10
MySQL---独有的多例过滤方式
SELECT a.user_name,b.timerstr,kills FROM user1 a JOIN user_kills b ON a.id=b.user_id WHERE(b.user_id,b.kills) IN( SELECT user_id,MAX(kills)
- 0赞 · 0采集
-
- qq_旭日阳光_1 2018-12-11
join方式，或者是多例过滤子查询的方式：
- 0赞 · 0采集
-
- weixin_慕斯3172537 2018-12-07
多列过滤方式2
- 0赞 · 0采集
-
- weixin_慕斯3172537 2018-12-07
多列过滤方式1
- 0赞 · 0采集
-
- BirdOfV 2018-05-26
@MySQL---独有的多例过滤方式
SELECT a.user_name,b.timerstr,kills FROM user1 a JOIN user_kills b ON a.id=b.user_id WHERE(b.user_id,b.kills) IN( SELECT user_id,MAX(kills) FROM user_kills GROUP BY user_id);
-
截图1赞 · 2采集
-
- 慕UI1567447 2018-04-09
未实现- 0赞 · 0采集
-
- kingdompeak 2017-08-15
- 多列过滤的使用场景：
-
截图0赞 · 0采集
-
- 滕玉龙 2017-06-25
- select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id=b.user_id where (b.user_id,b.kills) in (select user_id,max(kills)from user_kills group by user_id);
-
截图0赞 · 0采集
-
- 滕玉龙 2017-06-25
- MYSQL中独有的多例过滤方式
-
截图0赞 · 0采集
-
- 滕玉龙 2017-06-25
- select user_id,max(kills) as cnt from user_kills group by user_id; select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id =b.user_id join (select user_id,max(kills) as cnt from user_kills group by user_id) c on b.user_id=c.user_id and b.kills = c.cnt;
- 0赞 · 0采集
-
- diyangxia 2017-06-20
- 多列过滤 select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id=b.user_id where(b.user_id,b.kills) in ( select user_id,max(kills) from user_kills group by user_id);
-
截图0赞 · 0采集
-
- 如若不离 2017-05-03
- sql
-
截图0赞 · 0采集
-
- mukestudy2045 2017-04-03
- 子查询可以 where (a,b)in(t.a,t.b)
- 0赞 · 0采集
-
- 李东岳 2017-03-19
- DROP TABLE IF EXISTS im_skill; CREATE TABLE im_skill( id INT AUTO_INCREMENT PRIMARY KEY , user_id INT NOT NULL , skill NVARCHAR(10) NOT NULL , skill_level TINYINT NOT NULL ); INSERT INTO im_skill VALUES (NULL,1,'紧箍咒',5),(NULL,1,'打坐',4),(NULL,1,'念经',5),(NULL,1,'变化',0), (NULL,2,'紧箍咒',0),(NULL,2,'念经',0),(NULL,2,'腾云',3),(NULL,2,'变化',4),(NULL,2,'浮水',5), (NULL,3,'紧箍咒',0),(NULL,3,'念经',2),(NULL,3,'腾云',5),(NULL,3,'变化',5),(NULL,3,'浮水',3),(NULL,3,'请神',5), (NULL,4,'紧箍咒',0),(NULL,4,'念经',1),(NULL,4,'腾云',2),(NULL,4,'变化',2),(NULL,4,'浮水',4); SELECT * FROM im_skill;
- 0赞 · 0采集
-
- 慕粉2037406652 2017-02-22
- sql
-
截图0赞 · 0采集
-
- 慕粉2037406652 2017-02-22
- sql
- 0赞 · 0采集
-
- simonc 2017-02-01
- select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id=b.user_id join(select user_id,max(kills) as cnt from user_kills group by user_id)c on b.user_id=c.user_id and b.kills=c.cnt; mysql中独有的列过滤方式： select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id=b.user_id where (b.user_id,b.kills) in ( select user_id,max(kills) from user_kills group by user_ida )
- 0赞 · 0采集
-
- qq_鱼忘七秒_0 2016-09-05
- 多列过滤
- 0赞 · 0采集
-
- canfeng918 2016-07-14
- mysql子查询之多列过滤
-
截图0赞 · 1采集
-
- 霜花似雪 2016-06-23
- mysql中独有的列过滤方式： select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id=b.user_id where (b.user_id,b.kills) in ( select user_id,max(kills) from user_kills group by user_ida )
-
截图0赞 · 1采集
-
- mumukk 2016-06-11
- Mysql多列过滤
-
截图0赞 · 0采集
-
- haoguangxun 2016-05-27
- mysql中独有的列过滤方式： select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id=b.user_id where (b.user_id,b.kills) in ( select user_id,max(kills) from user_kills group by user_ida )
- 0赞 · 1采集
-
- 纠结的小猴子 2016-05-19
- mysql中独有的多列过滤
-
截图0赞 · 0采集
-
- 纠结的小猴子 2016-05-19
- 1312
-
截图0赞 · 0采集
-
- atwal 2016-03-31
- mysql中独有的多列过滤
-
截图0赞 · 1采集
-
- Godtrue 2016-01-01
- 多列过滤，这个曾经使用过，就是有多个条件相匹配
-
截图0赞 · 1采集
-
- IMOS 2015-12-23
- 多列子查询
-
截图0赞 · 0采集
数据加载中...