                        课程
                    
                        /数据库
                        
                            /MySQL
                        
                        /MySQL开发技巧（一）

Mysql

select d.user_name,c.timestr,kills

from(select user_id,timestr,kills

,(select count(*) from user_kills b where

b.user_id=a.user_id and a.kills <= b.kills) as cnt from user_kills a

group by user_id ,timestr ,kills)c join user1 d on c.user_id=d.id

where cnt <= 2;

加粗这儿是什么意思啊

Frank_Fu4373300

2017-07-06

源自：MySQL开发技巧（一） 3-1

关注问题我要回答

1327

操作

收起

3 回答

慕尼黑4560470
2018-03-15

多层子查询

0 回复有任何疑惑可以回复我~

收起回答

hen_nam
2017-11-05

SELECT a.user_name, b.timestr, b.kills FROM user1 a JOIN user_kills b ON a.id = b.user_id WHERE (SELECT COUNT(c.id) FROM user_kills c where c.user_id = b.user_id and c.kills >= b.kills) <= 2;

这条语句也可以获得相同的结果集。