I have a table called assignment_answers, which has the following attributes: assignment_answers_id, question_id and order. The order is an attribute, which can take a value from 0 to 9. I would like …
Tag: multiple-columns
Vertical Filter in MS-Excel by color
Is there a way to (not hide) but filter, columns in excel instead of rows. This is a sample of data, it continues further. I need to be able to say filter only the red columns – display only the red …
Using group by on multiple columns
I understand the point of GROUP BY x. But how does GROUP BY x, y work, and what does it mean? Answer Group By X means put all those with the same value for X in the one group. Group By X, Y means put all those with the same values for both X and Y in the one group.