Thursday, August 1, 2013

At least one column contains matching value

Hi Guys,


Is there any easy way to find out at least one column contains matching value


Ex

















































idval1val2val3val4val5val6
A101011
B000000
C010100

Any row with atleast one column contains 1


Result:


A


C


I dont want to check each column in where clause coz I have more than 10 columns in the table


Thanks



No comments:

Post a Comment