本文介绍了需要使用多个具有计数的oracle的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
HI ALL 我想使用多个帐户.请找到我下面的代码.我可以算一下 CUST_FOLIO_NO谁能告诉我也要计算com_ref_no的语法. 请提供您的建议.
HI ALL I WANT TO USE THE MULTIPLE HAVING COUNT. Pls find of my below code. I can able to take a count of CUST_FOLIO_NO Can anyone tell me the syntax for taking the count of com_ref_no also. Pls provide your suggestion.
select cust_folio_no,com_ref_no from d_trxn_perm where LOAD_MMYY IN ('052010','042010','032010') AND to_char(due_date,'mmyyyy') IN ('052010','042010','032010')and rownum < 10000 and rbi_reject_code IN ('01','11','02','12','03','13','04','14','05','15') and client_recon_status_code in ('F','F1') group BY CUST_FOLIO_NO HAVING COUNT(cust_folio_no)Rgds Jagadesh
Rgds Jagadesh
推荐答案嗨库玛, 请在下面的查询中尝试此操作, Hi Kumar, Try this below query, select cust_folio_no,com_ref_no from d_trxn_perm where LOAD_MMYY IN ('052010','042010','032010') AND to_char(due_date,'mmyyyy') IN ('052010','042010','032010')and rownum < 10000 and rbi_reject_code IN ('01','11','02','12','03','13','04','14','05','15') and client_recon_status_code in ('F','F1') group BY CUST_FOLIO_NO HAVING COUNT(cust_folio_no)=value and Count(com_ref_no) = value
希望对您有帮助. 问候, 忧郁的
Hope it''ll help you. Regards, Bluesathish
更多推荐
需要使用多个具有计数的oracle
发布评论