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;
加粗這兒是什么意思啊
2018-03-15
多層子查詢
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;
這條語句也可以獲得相同的結(jié)果集。
2017-07-08
我認(rèn)為這是利用兩個(gè)相同的表之間的同一個(gè)ID，對(duì)某個(gè)字段（kills）的值進(jìn)行比較，排序，淺見。