这是我需要从SQL转换为CodeIgniter的查询:
select *, count(username) as totalattempt from (select * from my_table order by created desc) as created2 group by `username` order by created desc
我尝试在Active Record CodeIgniter上进行搜索,但未能获得答案。
谢谢。
Codeigniter没有提供任何使用活动记录类的子查询的选项。
尝试:
$this->db->select('*')->from('my_table')->order_by('created','DESC');
$subQuery = $this->db->get_compiled_select();
/* Main Query */
$result = $this->db->select('created2.*, count(created2.username) as totalattempt')
->from('('.$subQuery.') as created2')
->group_by('created2.created','DESC')
->order_by('created2.username')
->get()
->result_array();
谢谢!
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句