SELECT query with subquery in the FROM clause using CodeIgniter's query builder [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed last month.

Improve this question

Is there a way or can someone translate this to code igniter query builder.

SELECT result.id, result.name, result.added
FROM (SELECT tbl.id, tbl.name, tbl.date_added
      FROM table tbl
      GROUP BY tbl.id) result
GROUP BY result.date_added

I already have my research(link below) but can't find anything like this(query above). https://www.codeigniter.com/userguide3/database/query_builder.html

https://arjunphp.com/how-to-write-subqueries-in-codeigniter-active-record/

And yes, this can be done using Stored Procedure but I have another reason why I need to implement this as query builder.

That's a funky operation you have there. What are you actually trying to achieve? If you can explain in plain English and provide some sample data and your expected result, we'll be able to provide better guidance. — mickmackusa
– mickmackusa ♦, Commented Oct 22 at 3:06

dain · Accepted Answer · 2018-08-22 06:18:53Z

1

try this one.

// Sub Query
         $this->db->select('result.id, result.name, result.added')->from('table tbl');
     $subQuery =  $this->db->get_compiled_select();

// Main Query
     $this->db->select('result.id, result.name, result.added')
     ->from('table tbl')
     ->where("id IN ($subQuery)", NULL, FALSE)
     ->get()
     ->result();

edited Aug 22, 2018 at 6:18

answered Aug 22, 2018 at 5:38

dain

801 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SELECT query with subquery in the FROM clause using CodeIgniter's query builder [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related