zend distinct

/*
10.4.3.10. Adding the DISTINCT Query Modifier

The distinct() method enables you to add the DISTINCT keyword to your SQL query.

Example 10.63. Example of the distinct() method
*/

<?php

// Build this query:
// SELECT DISTINCT p."product_name"
// FROM "products" AS p

$select = $db->select()
->distinct()
->from(array('p' => 'products'), 'product_name');

?>

/*
10.4.3.11. Adding the FOR UPDATE Query Modifier

The forUpdate() method enables you to add the FOR UPDATE modifier to your SQL query 
*/

 $select = $db->select() 
            ->from('material', 
                 array( 
                     'NumberOfCases' => new Zend_Db_Expr('COUNT(DISTINCT CIN_Number)'), 
                     'MMT_Number' 
                 )) 
            ->group('MMT_Number');