随笔分类 -  Mysql

Mysql
达到分组排序后取最大那条数据的效果
摘要：SELECT DISTINCT `NAME`, `sex` FROM test_demo t WHERE sex = ( SELECT max( t1.sex ) FROM test_demo t1 WHERE t1.`name` = t.`name` ) 阅读全文
posted @ 2022-10-11 11:14 xlisteven 阅读(7) 评论(0) 推荐(0)