php - 如何在codeigniter中查找重复记录

Question

我正在尝试编写一个查询来查找 Codegigniter 中的重复行，但它不起作用。我的代码(型号)

$this->db->select('*');
      $this->db->from('myTable sr');
      $this->db->join('table2 s','sr.st_id=s.st_id'); 
      if($conn!='')
      {
          $this->db->where($conn);
      }
      if($identity!='')
      {
          $where = "(s.student_id = '$identity' OR s.name LIKE '%$identity%')";
          $this->db->where($where);
      }
      if($duplicate != '')
      {
        $this->db->having('COUNT("sr.st_id")>1');          
      }
      if($limit_row!='')
      {
          $this->db->limit($limit_row,$starting);
      }
      $query = $this->db->get();
      var_dump($this->db->last_query($query));exit;
      return $query->result_array();

只返回第一条记录myTable 中有重复数据，我想找到那些重复数据

Answer 1

$this->db->select('*');
$this->db->from('myTable sr');
$this->db->join('table2 s','sr.st_id=s.st_id'); 
if($conn!='')
{
    $this->db->where($conn);
}
if($identity!='')
{
    $where = "(s.student_id = '$identity' OR s.name LIKE '%$identity%')";
    $this->db->where($where);
}
if($duplicate != '')
{
  $this->db->having('COUNT("sr.st_id")>1');
  $this->db->group_by('sr.st_id');          
}
if($limit_row!='')
{
    $this->db->limit($limit_row,$starting);
}
$query = $this->db->get();
var_dump($this->db->last_query($query));exit;
return $query->result_array();