例子:
$sql = 'SELECT SUM(o.price) as `sum`
FROM `order` o
WHERE o.customer_id ='.$profile->id;
$ret = Yii::$app->db->createCommand($sql)->queryScalar();
例子:
$sql = 'SELECT SUM(o.price) as `sum`
FROM `order` o
WHERE o.customer_id ='.$profile->id;
$ret = Yii::$app->db->createCommand($sql)->queryScalar();