SQL 语句 GROUP BY 分组查询查询其他列方法，使用内连接解决

SELECT
	a.ID 
FROM
	FOODJYXKZ_PERMIT a
	INNER JOIN ( 
	SELECT PERMITNUMBER, MAX( p.YXRQ ) YXRQ 
	FROM "FOODJYXKZ_PERMIT" p 
	GROUP BY p.PERMITNUMBER ) b 
	ON a.PERMITNUMBER = b.PERMITNUMBER 
	AND a.YXRQ = b.YXRQ