mysql - Zend 框架 : select distinct rows by two fields

Question

我有一个数据库表

field 1   field 21         22         32         32         21         12         2

我想要得到

field 1 field 21       22       32       21       1

尝试过

$select = $this->_dbTable->select()->from($this->_dbTable,array("DISTINCT(field_1) as field_1","DISTINCT(field_2) as field_2"));$select = $this->_dbTable->select()->from($this->_dbTable,array("DISTINCT(field_1, field_2) as field_1, field_2"));

PS:为什么这个 Zend Framework 这么难？!

Answer 1

正如 Sashi Kant 建议的那样，这可以通过 field_1、field_2 上的 group by 来完成。以下是如何使用 Zend DB 进行制作:

$select = $this->_dbTable->select()->from($this->_dbTable, array("field_1", "field_2"))
                                   ->group(array("field_1", "field_2"));