如上圖資料，想要group by g_id找到最大update_datetime的row:


學習

職場產業

國際

<div class="draft-block draft--p left"></div>
<div class="draft--imgNormal draft-block"><div><div style="height:818px" class="image-block-prerender" data-src="https://images.vocus.cc/840b9eee-7fec-441e-811a-100fcda3fce9.png" data-width="818" data-height="481" data-position="center"></div><figcaption class="imageCaption draft-block" style="cursor:text;display:block"></figcaption></div></div>
<div class="draft-block draft--p left">如上圖資料，想要group by g_id找到最大update_datetime的row:</div>
<pre class="public-DraftStyleDefault-pre draft-block"><pre class="draft--code-block">XXX::whereRaw('update_datetime in (select max(update_datetime) from xxx GROUP BY (g_id))')<br>-&gt;get();</pre></pre>
<div class="draft-block draft--p left"></div>
<div class="draft-block draft--p left"><span style="font-style: italic; ">本筆記參考:<br>1. </span><a href="https://laravelquestions.com/2021/03/29/get-maximum-value-containing-row-using-groupby-function-in-laravel/" target="_blank" class="draft--a"><span style="font-style: italic; ">https://laravelquestions.com/2021/03/29/get-maximum-value-containing-row-using-groupby-function-in-laravel/</span></a></div>

<p><br></p>
<p><br></p>
<p>如上圖資料，想要group by g_id找到最大update_datetime的row:</p>
<pre><code>XXX::whereRaw('update_datetime in (select max(update_datetime) from xxx GROUP BY (g_id))')<br>
-&gt;get();</code></pre>
<p><br></p>
<p><em>本筆記參考:<br>
1. </em><a href="https://laravelquestions.com/2021/03/29/get-maximum-value-containing-row-using-groupby-function-in-laravel/"><em>https://laravelquestions.com/2021/03/29/get-maximum-value-containing-row-using-groupby-function-in-laravel/</em></a></p>

如上圖資料，想要group by g_id找到最大update_datetime的row:

XXX::whereRaw('update_datetime in (select max(update_datetime) from xxx GROUP BY (g_id))')
->get();

本筆記參考:
1. https://laravelquestions.com/2021/03/29/get-maximum-value-containing-row-using-groupby-function-in-laravel/

Laravel get row with the max of a column, group by some cols