问题1:
SQL> select * from t_1; HM FY KSRQ JSRQ
---------- ---------- ----------- -----------
23 12 2005-1-31 2005-2-22
23 34 2005-2-19 2005-6-10
23 45 2005-4-1 2005-8-2
76 67 2005-1-2 2005-2-25
76 90 2005-2-27 2005-6-10
90 22 2005-2-25 2005-4-226 rows selectedSQL> select * from t_1 where to_char(ksrq,'yyyymmdd') in (select max(to_char(ksrq,'yyyymmdd')) from t_1 group by hm); HM FY KSRQ JSRQ
---------- ---------- ----------- -----------
23 45 2005-4-1 2005-8-2
76 90 2005-2-27 2005-6-10
90 22 2005-2-25 2005-4-22问题2:
SQL> select * from t_1 where ksrq in (select max(ksrq) from t_1 where ksrq not in (select max(ksrq) from t_1 group by hm) group by hm); HM FY KSRQ JSRQ
---------- ---------- ----------- -----------
23 34 2005-2-19 2005-6-10
76 67 2005-1-2 2005-2-25
SQL> select * from t_1; HM FY KSRQ JSRQ
---------- ---------- ----------- -----------
23 12 2005-1-31 2005-2-22
23 34 2005-2-19 2005-6-10
23 45 2005-4-1 2005-8-2
76 67 2005-1-2 2005-2-25
76 90 2005-2-27 2005-6-10
90 22 2005-2-25 2005-4-226 rows selectedSQL> select * from t_1 where to_char(ksrq,'yyyymmdd') in (select max(to_char(ksrq,'yyyymmdd')) from t_1 group by hm); HM FY KSRQ JSRQ
---------- ---------- ----------- -----------
23 45 2005-4-1 2005-8-2
76 90 2005-2-27 2005-6-10
90 22 2005-2-25 2005-4-22问题2:
SQL> select * from t_1 where ksrq in (select max(ksrq) from t_1 where ksrq not in (select max(ksrq) from t_1 group by hm) group by hm); HM FY KSRQ JSRQ
---------- ---------- ----------- -----------
23 34 2005-2-19 2005-6-10
76 67 2005-1-2 2005-2-25
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货