Re: Loop repeat the last line (last entry of the cursor)

[Peter Brawley]

Invalid query: select *, ... group by nome_aluno will return arbitrary results for every non-aggregated column except nome_aluno that does not have a strictly 1:1 relationship with alone_nome.

In general, avoid Select * ... Group By ....

Decide which columns you must Group By, and include only those columns in the Select statement. If you need other non-aggregated columns, retrieve them from a Join to the aggregation query.