随笔分类 -  sql

sql
oracle取去掉重复得到时间是最新的值
摘要：SELECT * FROM jf_applymain p WHERE (p.cardid,p.acceptdate) IN ( SELECT j.cardid,MAX(j.acceptdate) FROM jf_applymain j WHERE j.isupdated ='1' GROUP BY j.cardid)AND p.syear = (select to_char(sysdate,'yyyy') as nowYear from dual)ORDER BY p.acceptdate DESC得到年份(select to_char(sysdate,' 阅读全文
posted @ 2011-11-02 11:14 方坚.cn 阅读(394) 评论(0) 推荐(0)