Help in group by query

[dilippanda]

Hi,

Please help me in the following query.

SELECT
a.bcast_id ,
a.bcast_file_nm ,
a.clickthru_url _cd ,
a.list_id ,
a.prs_id ,
a.resp_cd ,
a.run_seq ,
COUNT(a.resp_cd ) ,
c.src_grp_cd ,
b.site_cd
FROM
gca_cbx_respons e_test a ,
gca_program_run _hist b ,
campaign_master c
WHERE
a.list_id=b.lis t_id
AND
a.run_seq=b.cam paign_run_seq
AND
b.campaign_cd=c .campaign_cd
GROUP BY
a.bcast_id ,
a.bcast_file_nm ,
a.clickthru_url _cd ,
a.list_id ,
a.prs_id ,
a.resp_cd ,
a.run_seq ,
c.src_grp_cd ,
b.site_cd
HAVING
a.resp_ts
BETWEEN
to_date('04-AUG-2005 00:01:32','DD-MON-YYYY HH24:MI:SS')
AND
to_date('04-AUG-2005 00:01:32','DD-MON-YYYY HH24:MI:SS');

But the following group by query is throwing error that a.resp_ts is not a group by function.

But i don't want to add a.resp_ts in group by clause.

Please help me in this query.

Thanks,
Dilip

[madnanalim]

Hi.
Plz check the following Query
SELECT
a.bcast_id ,
a.bcast_file_nm ,
a.clickthru_url _cd ,
a.list_id ,
a.prs_id ,
a.resp_cd ,
a.run_seq ,
COUNT(a.resp_cd ) ,
c.src_grp_cd ,
b.site_cd
FROM
gca_cbx_respons e_test a ,
gca_program_run _hist b ,
campaign_master c
WHERE
a.list_id=b.lis t_id
AND
a.run_seq=b.cam paign_run_seq
AND
b.campaign_cd=c .campaign_cd
And a.resp_ts Between to_date('04-AUG-2005 00:01:32','DD-MON-YYYY HH24:MI:SS')
AND to_date('04-AUG-2005 00:01:32','DD-MON-YYYY HH24:MI:SS')
GROUP BY
a.bcast_id ,
a.bcast_file_nm ,
a.clickthru_url _cd ,
a.list_id ,
a.prs_id ,
a.resp_cd ,
a.run_seq ,
c.src_grp_cd ,
b.site_cd ;

[rnsahu]

Hi.
Plz check the following Query
SELECT
a.bcast_id ,
a.bcast_file_nm ,
a.clickthru_url _cd ,
a.list_id ,
a.prs_id ,
a.resp_cd ,
a.run_seq ,
COUNT(a.resp_cd ) ,
c.src_grp_cd ,
b.site_cd
FROM
gca_cbx_respons e_test a ,
gca_program_run _hist b ,
campaign_master c
WHERE
a.list_id=b.lis t_id
AND
a.run_seq=b.cam paign_run_seq
AND
b.campaign_cd=c .campaign_cd
And a.resp_ts Between to_date('04-AUG-2005 00:01:32','DD-MON-YYYY HH24:MI:SS')
AND to_date('04-AUG-2005 00:01:32','DD-MON-YYYY HH24:MI:SS')
GROUP BY
a.bcast_id ,
a.bcast_file_nm ,
a.clickthru_url _cd ,
a.list_id ,
a.prs_id ,
a.resp_cd ,
a.run_seq ,
c.src_grp_cd ,
b.site_cd ;


see here we have to remember 1 thing, "having clause" logic is related to the result of group functions,as opposed to columns and expressions for individual rows.