Re: How could select count(*) return no row ???
From: Alain Barrette <barrette_at_jrv.qc.ca>
Date: 1995/08/27
Message-ID: <41q8e8$kkq_at_volcano.jrv.qc.ca>#1/1
Date: 1995/08/27
Message-ID: <41q8e8$kkq_at_volcano.jrv.qc.ca>#1/1
barrette_at_jrv.qc.ca (Alain Barrette) wrote:
>If I use the following statement
>Select count(*) from table
>where 1 = 0,
>It return 0.
>If however I try to do something like
>Select count(*) from table
>where 0 = (select count(*) from table where 1 = 0);
>It give me no rows selected ?!?!?
>How or why could this be ?
Thanks to all of you who responded...
It seem that the problem was a buggy version of sqlplus... Using a newer version we get with an upgrade i don't get it anymore... Received on Sun Aug 27 1995 - 00:00:00 CEST