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
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