sql描述:获取每个类别下最新创建的对象

SELECT
	a.* 
FROM
	t_goods_base a
WHERE
	a.create_time = (
		SELECT MAX
			( b.create_time ) 
		FROM
			cwh.t_goods_base AS b 
		WHERE
			a.wh_id = b.wh_id 
	)