Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression

Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression

just
Newbie
Posts: 3
Threads: 1
Joined: Apr 2024
Reputation: 0

04-12-2024, 01:31 PM

return $this;

Code:
$this->builder()

            ->select(‘name, address’)

            ->selectSum('TOTAL’)

            ->groupBy(‘name’, ‘address')

            ->limit($limit,  $offset);

        return $this;

Hi, im new to this forum, i tried to make pagination, everything work without group by.
can i get some help?

im using 4.4.6 version.

Messages In This Thread

Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by just - 04-12-2024, 01:31 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by kenjis - 04-12-2024, 06:09 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by just - 04-13-2024, 08:00 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by kenjis - 04-13-2024, 08:11 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by just - 04-13-2024, 08:36 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by kenjis - 04-13-2024, 08:56 PM