To get number of columns with a specific value in one row
I have a table "Cinema" with Cinema_ID as my PK and all the seats as
columns with data type bit (1 = booked, 0 = available) eg. Cinema_ID, A1,
A2, A3, A4, A5, B1, B2, B3, B4, B5, ..., E5. Is it possible to only count
the columns with a row value of 1?
No comments:
Post a Comment