group by 取时间最近的一条数据

group by 取时间最近的一条数据

SELECT *
FROM 
(SELECT * FROM nk_bsscore
ORDER BY testFinishTime DESC )a
GROUP BY userkey

以下写法会报错

SELECT * FROM nk_bsscore
ORDER BY testFinishTime DESC
GROUP BY userkey