select * from table where 3 > 2 what will return this query? anyone explain this query??

Posted by amanueljoseph-9523 under Sql Server on 12/10/2012 | Points: 10 | Views : 1140 | Status : [Member] | Replies : 2
Hi,

select * from table where 3 > 2 what will return this query? anyone explain this query??




Responses

Posted by: perfectchourasia-9163 on: 12/11/2012 [Member] Starter | Points: 25

Up
0
Down
it will work same as select * from table because where where condition is always true .

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

amanueljoseph-9523, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pavanandey on: 12/11/2012 [Member] Bronze | Points: 25

Up
0
Down
since the condition is always true it returns the entire table

Thanks
Pavan Kumar
Mark Answer if this fits the need

amanueljoseph-9523, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response