需要使用多个具有计数的oracle

本文介绍了需要使用多个具有计数的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