SQL 分组后获取其中一个字段最大值的整条记录
摘要:
方法一:(效率最高)select * from test as a where typeindex = (select max(b.typeindex) from test as b where a.type = b.type );方法二:(效率次之)select a.* from test a,( 阅读全文
posted @ 2019-11-21 10:28 MIUMIUBLING 阅读(937) 评论(0) 推荐(0) 编辑