How to group by three fields in SQL Oracle if you need to get 10 fields in SELECT?

Question

Oracle

It is necessary in the query, where 10 fields are selected in SELECT, to group by 3 fields in order to count the number of record clones for these three fields. Is it in principle possible?
Of course, I understand that Oracle will not understand from which record to display data on fields that are not in group by, and therefore swears. For example, MySQL does not pay attention to such a thing.

Answer 1

MySQL is the only DBMS that does this wrong, and this is cured by setting sql_mode to ONLY_FULL_GROUP_BY. Wrap GROUP BY in a subquery and select the missing fields with an external SELECT, or use window functions :

SELECT 
    name,
    lastname,
    count(*) OVER (PARTITION BY group_col1, group_col2, group_col3),
FROM table

In SQL Server, this construction works, in Oracle, in theory, it should too.