Get Last Record In Each MySQL Group |
I need to this SQL query to get last record in each group:
PHP Code: SELECT id, category_id, post_title how do can I work with query builder to get last record in each group in codeigniter 4?
Use Subqueries method. ie:
PHP Code: $builder = $this->db->table('posts'); remember, you need to add in top of your model: Code: use CodeIgniter\Database\BaseBuilder; |
Welcome Guest, Not a member yet? Register Sign In |