<p>我有 40 个提供商和 10,000 个产品，但我想显示每个提供商的 1 个产品</p> <table class="s-table"> <thead> <tr> <th>品牌</th> <th>提供商</th> <th>产品</th> <th>网址</th> </tr> </thead> <tbody> <tr> <td>闪电</td> <td>务实的游戏</td> <td>命运夫人</td> <td>链接</td> </tr> <tr> <td>闪电</td> <td>Isoftbet</td> <td>万圣节杰克</td> <td>链接</td> </tr> <tr> <td>闪电</td> <td>务实的游戏</td> <td>甜蜜的富矿</td> <td>链接</td> </tr> <tr> <td>闪电</td> <td>Isoftbet</td> <td>热带保安</td> <td>链接</td> </tr> <tr> <td>闪电</td> <td>网络</td> <td>皇家马铃薯</td> <td>链接</td> </tr> <tr> <td>闪电</td> <td>网络</td> <td>命运夫人</td> <td>链接</td> </tr> </tbody> </table> <p>这就是我现在的 SQL 表。但我想显示每个提供商的 1 项，例如：</p> <table class="s-table"> <thead> <tr> <th>品牌</th> <th>提供商</th> <th>产品</th> <th>网址</th> </tr> </thead> <tbody> <tr> <td>闪电</td> <td>务实的游戏</td> <td>命运夫人</td> <td>链接</td> </tr> <tr> <td>闪电</td> <td>Isoftbet</td> <td>万圣节杰克</td> <td>链接</td> </tr> <tr> <td>闪电</td> <td>网络</td> <td>皇家马铃薯</td> <td>链接</td> </tr> </tbody> </table> <p>这是我的代码 `</p> <pre class="brush:php;toolbar:false;">&lt;?php /* Attempt MySQL server connection. Assuming you are running MySQL server with default setting (user 'root' with no password) */ $link = mysqli_connect(&quot;localhost&quot;, &quot;newuser1&quot;, &quot;p,+Dn@auTD3$*G5&quot;, &quot;newdatabse&quot;); // Check connection if($link === false){ die(&quot;ERROR: Could not connect. &quot; . mysqli_connect_error()); } // Attempt select query execution $sql = &quot;SELECT * FROM tablename WHERE Brand='Coolcasino' and Provider IN ('Pragmatic Play','Isoftbet','Netent') ;&quot;; if($result = mysqli_query($link, $sql)){ if(mysqli_num_rows($result) &gt; 0){ echo &quot;&lt;table&gt;&quot;; echo &quot;&lt;tr&gt;&quot;; echo &quot;&lt;th&gt;Brand&lt;/th&gt;&quot;; echo &quot;&lt;th&gt;Provider&lt;/th&gt;&quot;; echo &quot;&lt;th&gt;Product&lt;/th&gt;&quot;; echo &quot;&lt;th&gt;URL&lt;/th&gt;&quot;; echo &quot;&lt;/tr&gt;&quot;; while($row = mysqli_fetch_array($result)){ echo &quot;&lt;tr&gt;&quot;; echo &quot;&lt;td&gt;&quot; . $row['Brand'] . &quot;&lt;/td&gt;&quot;; echo &quot;&lt;td&gt;&quot; . $row['Provider'] . &quot;&lt;/td&gt;&quot;; echo &quot;&lt;td&gt;&quot; . $row['Product'] . &quot;&lt;/td&gt;&quot;; echo &quot;&lt;td&gt;&quot; . $row['URL'] . &quot;&lt;/td&gt;&quot;; echo &quot;&lt;/tr&gt;&quot;; } echo &quot;&lt;/table&gt;&quot;; // Close result set mysqli_free_result($result); } else{ echo &quot;No records matching your query were found.&quot;; } } else{ echo &quot;ERROR: Could not able to execute $sql. &quot; . mysqli_error($link); } // Close connection mysqli_close($link); ?&gt;</pre> <p>如果有人可以的话请帮助我`</p>

$sql = "SELECT * FROM tablename WHERE Brand='Coolcasino' and Provider IN ('Pragmatic Play','Isoftbet','Netent') GROUP BY  Provider;";

select Brand,
       Provider,
       Product,
       URL
from (   select Brand,
                Provider,
                Product,
                URL,
                row_number() over(partition by Provider order by rand()) as row_num
         from tablename
         where Brand='Lightning' 
         and Provider IN ('Pragmatic Play','Isoftbet','Netent') 
      ) as rand_prod
where row_num=1;