Group By ||

Not able to completely understand GROUP BY ||. Can you explain this in detail? Getting confused.

Welcome to the forums!
What problem are you stuck on (link to exercise)? What code have your written so far?

When you say ā€™GROUP BY II do you mean GROUP BY 2 ?

ā€œ2ā€ denotes the second column in the SELECT statement.

2 Likes

Welcome to the forums :grinning:

Iā€™m gonna assume you are referring to this exercise.

But basically it is what @lisalisaj just said. You can use numbers for representing the column you wanna group by or order by. The first column in the SELECT statement will be represented with a 1, the second one with a 2 and so on.

1 Like