随笔分类 -  sql

摘要：获取分组后取某字段最大一条记录方法一：(效率最高)select * from test as awhere typeindex = (select max(b.typeindex)from test as bwhere a.type = b.type );方法二：(效率次之)selecta.* fr 阅读全文