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_
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 (sysd
>Description:
Running the mysql_install_db or configure scripts fail to install
database tables. mysqld cannot find libgthreads.so even though it is
in /usr/local/lib. Script also complains that libc are not 100 %
compatible; I think I have the latest versio