How could select count(*) return no row ???
From: Alain Barrette <barrette_at_jrv.qc.ca>
Date: 1995/08/18
Message-ID: <410h0t$972_at_volcano.jrv.qc.ca>#1/1
Date: 1995/08/18
Message-ID: <410h0t$972_at_volcano.jrv.qc.ca>#1/1
If I use the following statement
Select count(*) from table
If however I try to do something like
Select count(*) from table
It give me no rows selected ?!?!?
where 1 = 0,
It return 0.
where 0 = (select count(*) from table where 1 = 0);
How or why could this be ? Received on Fri Aug 18 1995 - 00:00:00 CEST