Re: Select count(*) on view

From: Anurag Varma <avoracle_at_gmail.com>
Date: 14 Feb 2007 05:27:10 -0800
Message-ID: <1171459630.875038.245740@s48g2000cws.googlegroups.com>

On Feb 14, 6:11 am, joker197cin..._at_gmail.com wrote:
> Is it possible, according to you, that these 2 instructions:
>
> select * from view_first
>
> select count(*) from view_first
>
> where "view_first" is a view, return different rowcount?
>
> I mean that in "select * from view_first" I browse all rows through a
> GUI and I can see 200 rows but if I query the scalar value "select
> count(*) from view_first" I obtain only 150.
>
> I can't understand why...

Yes its possible.
Between the two queries if I delete 50 rows from the underlying table, I can get your results.
There are a lot other ways I can get the results you see..

Is that what you are asking? Or do you want to be more specific?

Anurag Received on Wed Feb 14 2007 - 07:27:10 CST