mysql 分组取得 每组记录数

SELECT
*
FROM
film AS a
WHERE 2>
(
SELECT count(*) FROM
film
WHERE  filmTemplateId <> '' and filmTemplateId=a.filmTemplateId and addTime>a.addTime

) order by filmTemplateId

取得每组最新的两条记录

获取分组后取某字段最大一条记录
方法一：(效率最高)
select * from test as a 
where typeindex = (select max(b.typeindex) 
from test as b 
where a.type = b.type );