goods表如下:
name | time | product |
A | 2016-1-2 | WFEY |
B | 2016-2-17 | ASG |
A | 2017-1-10 | SGH |
C | 2015-4-5 | HRT |
C | 2016-7-12 | XCC |
A | 2017-3-4 | ESFW |
SELECT g.name,g.product
FROM goods g
INNER JOIN (
SELECT MIN(time) AS t
FROM goods
GROUP BY name ) tmp
ON tmp.t=g.time;