sql去重（根据两个字段去重）
今天搞这个，差点被搞残废了，幸亏DB组的哥们帮忙，这里mark下：
今天搞这个，差点被搞残废了，幸亏DB组的哥们帮忙，这里mark下： select * from( select rate_id,title,TO_CHAR(RATE_PUBL_DATE, YYYY-MM-DD HH:MM) RES_DATE from( select * from( select sec_uni_code, RATE_PUBL_DATE, RATE_ID,【主体评级】 || ISS_RATE_TITLE_NEW title ,row_number() over(partition by sec_uni_code,rate_publ_date order by 1) r from wxdata.wx_sec_comm where sec_uni_code = 103037402 ) where r=1)order by RES_DATE desc)
select * from( select * from(
select rate_id,title,TO_CHAR(RATE_PUBL_DATE, YYYY-MM-DD HH:MM) RES_DATE from( select rate_id,title,TO_CHAR(RATE_PUBL_DATE, YYYY-MM-DD HH:MM) RES_DATE from(
select * from( select * from(
select sec_uni_code, RATE_PUBL_DATE, select sec_uni_code, RATE_PUBL_DATE,
RATE_ID,【主体评级】 || ISS_RATE_TITLE_NEW title RATE_ID,【主体评级】 || ISS_RATE_TITLE_NEW title
,row_number() over(partition by sec_uni_code,rate_publ_date order by 1) r ,row_number() over(partition by sec_uni_code,rate_publ_date order by 1) r
from wxdata.wx_sec_comm from wxdata.wx_sec_comm
where sec_uni_code = 103037402 where sec_uni_code = 103037402
) where r=1)order by RES_DATE desc) ) where r=1)order by RES_DATE desc)
select * from( select rate_id,title,TO_CHAR(RATE_PUBL_DATE, YYYY-MM-DD HH:MM) RES_DATE from( select * from( select sec_uni_code, RATE_PUBL_DATE, RATE_ID,【主体评级】 || ISS_RATE_TITLE_NEW title ,row_number() over(partition by sec_uni_code,rate_publ_date order by 1) r from wxdata.wx_sec_comm where sec_uni_code = 103037402 ) where r=1)order by RES_DATE desc)
