title: getting error of ora 00979 not a group by expression in lumen with oracle
body: <blockquote>
  <p>I am using lumen with oracle database and getting error on query with
  group by.not undestand the problem because its working with mysql.</p>
  </blockquote>
  <pre><code>&quot;ora 00979 not a group by expression&quot;
  </code></pre>
  <p>my query :</p>
  <pre><code>DB::table('company')
  -&gt;select('company.name','branch.id','branch.name','branch.id','branch.branch_com_id')
  -&gt;leftjoin('branch', 'company.id', '=', 'branch_com_id')
  -&gt;groupBy('branch.branch_com_id')
  -&gt;get()
  -&gt;toArray();
  </code></pre>
  <p><strong>I am trying to groupby rows from branch table with branch_com_id but its showing above error.
  i tried with adding <code>strict mode =&gt; false</code> in .env and database.php but still its not working for me.</strong></p>