当前位置：Gxlcms > 数据库问题 > SQL开发技巧

SQL开发技巧

时间：2021-07-01 10:21:17 帮助过：2人阅读

a.user_name, b.timestr, b.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

where子句方法

select a.user_name, b.timestr, b.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) as cnt from user_kills group by user_id);

 

SQL开发技巧

标签：

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！