title: How to get all the columns, but have to group by only 2 columns in sql query
body: <p>I have a table <code>Employees</code>, which has Fields as below:</p>
  
  <pre><code>Employee_name,Employee_id,Employee_status,Employee_loc,last_update_time.
  </code></pre>
  
  <p>This table does not have any constraint.
  I have tried the below query. </p>
  
  <pre><code>select Employee_name, count(1) 
  from Employees 
  where Employee_status = 'ACTIVE' 
  Group by Employee_name,Employee_loc 
  having count(Employee_name) &gt; 1 
  order by count(Employee_name)  desc
  </code></pre>
  
  <p>In the select, I need to get <code>Employee_id</code> too.. Can any one help on how to get that?</p>