$sql = "SELECT * FROM `l_company_distributor_message` WHERE id IN (SELECT MAX(id) FROM `l_company_distributor_message` WHERE distributor_id = ".$this->_distributorId." GROUP BY company_id )"; $message = Yii::$app->getDb()->createCommand($sql)->queryAll();
yii 使用原生sql 查询 以某一字段分组 每个字段取出最新的一条数据
最新推荐文章于 2022-05-06 09:58:25 发布