Re: scratch head to the SQL statement of where 1=1

1 = 1 returns true... generic statement
if statement is generated based on conditions then   and x = y statement can then be added without a problem

ie
select count(*) from table
where 1 = 1
and x = y
and ... will be legit

whereas
select count(*) from table
and x=y ... is not legit.

"Katak" <kahtat_at_yahoo.com> wrote in message news:9n9er1$fbe$1_at_dahlia.singnet.com.sg...
> dear all,
>
> i am having problems understanding a particular SQL statement
> let me paint this scenario to u
>
> SQL statement 1 = select count(*) from mytable
>
> when SQL statement 1 is executed, the value returned is X for example.
>
> SQL SQL statement 1 = select count(*) from mytable where 1=1
> this will also return a value of X.
>
> anyone can enlighten me on this? thanks
> the database used is Oracle 8.1.7
>
>
>
>
Received on Thu Sep 06 2001 - 23:23:13 CDT