Laravel中在某些條件下COUNT且指定欄位value重複只算一次:
DB::raw('COUNT(DISTINCT customer.customer_id AND IF(contact_result.invalid_flag = "Y", 1, NULL)) AS contact_inval

學習

職場產業

國際

<div class="draft-block draft--p left">在某些條件下COUNT且指定欄位value重複只算一次:</div>
<div class="draft-block draft--p left">DB::raw('COUNT(DISTINCT IF(contact_result.invalid_flag = "Y", customer.customer_id, NULL)) AS contact_invalid_count')</div>
<div class="draft-block draft--p left"></div>
<div class="draft-block draft--p left"></div>

<p>在某些條件下COUNT且指定欄位value重複只算一次:</p>
<p>DB::raw('COUNT(DISTINCT IF(contact_result.invalid_flag = "Y", customer.customer_id, NULL)) AS contact_invalid_count')</p>
<p><br></p>
<p><br></p>

在某些條件下COUNT且指定欄位value重複只算一次:

DB::raw('COUNT(DISTINCT IF(contact_result.invalid_flag = "Y", customer.customer_id, NULL)) AS contact_invalid_count')

Laravel COUNT with IF condition and DISTINCT