SELECT
catalogue,
hc,
sum(number) AS number,min(dtime)
person,
dtime
FROM
hctotal
GROUP BY
dtime DESC
ORDER BY
catalogue DESC
catalogue,
hc,
sum(number) AS number,min(dtime)
person,
dtime
FROM
hctotal
GROUP BY
dtime DESC
ORDER BY
catalogue DESC
catalogue,
hc,
sum(number) AS number,min(dtime)
person,
dtime
FROM
hctotal
GROUP BY
hc DESC
ORDER BY catalogue DESC
还是没有显示最近的时间
SELECT
catalogue,
hc,
sum(number) AS number,
person,
max(dtime)
FROM
hctotal
GROUP BY
hc DESC
ORDER BY
catalogue DESC
这样就行了。多谢