mysql - 如何在 Codeigniter 中编写此子查询 Select AVG with Limit

Question

SELECT AVG(harian) a from (select harian from sla limit 2) b

以上是在 Heidisql 中执行的工作，

刚刚尝试过以下:

$rata2 = $this->db->query('SELECT AVG(harian) a from (select harian from sla limit 2) b');

但是，似乎没有输出，请帮忙，谢谢

Answer 1

// Sub Query
$this->db->select('harian')->from('sla')->limit(2);
$subQuery =  $this->db->get_compiled_select();

// Main Query
$rata2 = $this->db->select('AVG(harian)')
     ->from($subQuery)
     ->get();

return $rata2; 

或者如果你想返回数组中的数据

// Sub Query
$this->db->select('harian')->from('sla')->limit(2);
$subQuery =  $this->db->get_compiled_select();

// Main Query
$rata2 = $this->db->select('AVG(harian)')
     ->from($subQuery)
     ->get()
     ->toArray();

return $rata2;