/*
10.4.3.10. Adding the DISTINCT Query Modifier
The distinct() method enables you to add the
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
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');
UPDATE modifier to your SQL query
*/
*/
?>
/*
10.4.3.11. Adding the FOR UPDATE Query Modifier
The forUpdate() method enables you to add the FOR
2：SELECT COUNT(DISTINCT(CIN_Number)) as NumberofCases, MMT_Number as NumberOfCase FROM material
$select=$db->select()
->from('material',
array(
'NumberOfCases'
->from('material',
array(
'NumberOfCases'
=>new Zend_Db_Expr('COUNT(DISTINCT CIN_Number)'),
'MMT_Number'
))
->group('MMT_Number');
'MMT_Number'
))
->group('MMT_Number');
