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
原创
2021-05-08 18:38:18 ·
521 阅读 ·
0 评论