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 : 2106 | Status : [Member] | Replies : 2

Hi,

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

Reply | Reply with Attachment

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

0	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

0	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

Latest Posts