Is there is query with which I can get the sum of elements in one row?
I am trying to develop an atttendance application. Design as follows-
<date1> <date2> <date3> <date4>--- <attended>
<rollno1> 1 0 1 1 3
<rollno2> 0 0 1 1 2
<rollno3> 0 1 0 0 1
I am trying to get the attended field.
Is it possible, or is it a bad design?
Please suggest an alternate design if so.
I am absolutely new to database design.