I have a question please, I have a cognos data manager job in which I have cognos sql query as entry dataset, the problem is that this query contains the group by clause and when I take that same query and try to execute it on the oracle database I get the “ORA-00979 not a group by expression”, I can simply correct the query by adding the missing columns in the group by but the number of rows after the correction is too big, the issue is that the query as it is works fine in cognos data manager job and it return 400000 rows, but when I take it and correct the group by issue I get 2.5 milllion rows.

Is there and method to reliably convert cognos sql to ordinary sql ?

I asked chatgpr but he’s providing the correction that I do manually.