需要使用多个具有计数的oracle [英] Need to use multiple having count 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！