over 开窗函数使用说明

---CUR_CD              VARCHAR2(18)   Y                币种 

---CORP_ORG            VARCHAR2(10)                    法人机构编号 

---AGMT_ID             VARCHAR2(40)                    合同号  

---BUSINESSTYPE        VARCHAR2(18)   Y                业务品种

----此SQL含义 汇总 b.cur_cd, b.Corp_Org取一行

select * from (SELECT b.Agmt_Id,
                          b.Corp_Org,
                          b.Cur_Cd,
                          b.Businesstype,
                          
                          Row_Number() Over(PARTITION BY b.cur_cd, b.Corp_Org  ORDER BY b.cur_cd, b.Corp_Org) Row_No
                     FROM dwm.b_m_Business_Contract b)
                     where Row_no=1
        AGMT_ID                 CORP_ORG CUR_CD  BUSINESSTYPE   Row_No
1	20120801000126	        15601	T00CNY	2050030	        1
2	320090419000005	        15601	T00CNY	3010	        2
3	20130129000184	        15601	T00CNY	2050030	        3
4	200612750372093-5	15601	T00CNY		        4
5	20061275037