$q = $this->db->select('
books.title,
reserved_books.id,
reserved_books.isbn,
reserved_books.price,
reserved_books.item_sold,
reserved_books.date_sold,
reserved_books.total_amount
')
->from('reserved_books')
->join('books','reserved_books.isbn= books.isbn')
->limit($limit,$offset);
我如何在查询中使用distinct?reserved_books.isbn是唯一的。
尝试以下:
$this->db->distinct();
但是Distinct并非总能奏效。您应该添加->group_by("name_of_the_column_which_needs_to_be unique");
$this->db->group_by('column_name');
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句