Use the same query except replace
nvl((c.sr_num),0))
with
count(*)
John
Lance Prais wrote:
I have a question about using count in an Intersect Statement. I want to
get the total count of the following SQL Statement: How would I do this?
SELECT
nvl((c.sr_num),0)),
FROM
s_evt_act a,
I have a question about using count in an Intersect Statement. I want to
get the total count of the following SQL Statement: How would I do this?
SELECT
nvl((c.sr_num),0)),
FROM
s_evt_act a,
s_srv_req c
WHERE
a.sra_sr_id = c.row_id and
a.priv_flg = 'N' and
a.x_cp_created between