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
SQL 语句 GROUP BY 分组查询查询其他列方法,使用内连接解决
最新推荐文章于 2023-01-30 09:40:48 发布