i have table, has 5 boolean columns, few other columns, so:
rowid | bool1 | bool2 | bool3 | bool4 | bool5 | other1 | other2 | other3 | 1 | 1 | 1 | 0 | 0 | 0 | 5 | 34 | 'foo' | 2 | 0 | 1 | 0 | 1 | 0 | 7 | 42 | 'bar' | 3 | 1 | 1 | 1 | 1 | 1 | 12 | 7 | 'blah' | 4 | 0 | 1 | 0 | 0 | 0 | 5 | 34 | 'blah' |
i want way select rows in @ least 2 of bool columns true. in case: rows 1, 2 , 3 not 4.
any suggestions?
Comments
Post a Comment