title: Zend Select group by Field
body: <p>I have a query as below:</p>
  
  <pre><code>select status, count(id) as units from myTable group by status
  </code></pre>
  
  <p>I have a Zend_Db_Table object at my displosal for the table in use, i am trying the below mentioned snippet to create the query above:</p>
  
  <pre><code>$objTable= new Application_Model_DbTable_MyTable();
  $select = $objTable -&gt; select(Zend_Db_Table::SELECT_WITH_FROM_PART)
                      -&gt; setIntegrityCheck(false); // i am also using joins to create the query, but this is not of concern
  $select -&gt; columns(array(
             'status' =&gt; new Zend_Db_Expr('DISTINCT(STATUS)'),
             'units'  =&gt; new Zend_Db_Expr('COUNT(id)')
             ));
  $select -&gt; group('status');
  </code></pre>
  
  <p>the query created from the above snippet is as follows:</p>
  
  <pre><code>select myTable.*, DISTINCT(STATUS) as status, COUNT(id) as units from myTable group by status
  </code></pre>
  
  <p>I want to remove the <code>myTable.*</code> from the query generated.</p>