This is how my license table look like.. i want to select only row that has atleast one "1".
which means i don't want to select any row that has full of zeros..
Jump to Post
Use a calculated column that sums all your 0/1 columns. Then you can just add
WHERE summed > 0
All 5 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.