The problem lies in what to do with the multiple results implied by this question. If you want to use a cursor and group, then fetch, no problem. If you merely want to group and select into, then what happens when you return multiple results? You can execute that select, but it could very well generate errors often.

What do you want to do?