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,
s_srv_req c
WHERE
a.sra_sr_id = c.row_id and
a.priv_flg = 'N' and
a.x_cp_created between (sysdate-1) and
sysdate
intersect
SELECT
(nvl((b.sr_num),0))
FROM
s_srv_req b
WHERE
b.x_cp_updated between (sysdate-1) and sysdate
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
