---员工信息表
SELECT * FROM emp t
WHERE t.hiredate IN (
SELECT max(t.hiredate) FROM emp t
GROUP BY to_char(t.hiredate,'yyyymm'))
ORDER BY t.hiredate
SELECT * FROM emp t
WHERE t.hiredate IN (
SELECT max(t.hiredate) FROM emp t
GROUP BY to_char(t.hiredate,'yyyymm'))
ORDER BY t.hiredate
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货