SQL查询每个用户首次购买商品

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;