zend distinct
时间:2011-05-31
来源:长城的草
在手机上看
手机扫描阅读
/*
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
*/
2:SELECT COUNT(DISTINCT(CIN_Number)) as NumberofCases, MMT_Number as NumberOfCase FROM material
$select = $db->select()
->from('material',
array(
'NumberOfCases' => new Zend_Db_Expr('COUNT(DISTINCT CIN_Number)'),
'MMT_Number'
))
->group('MMT_Number');
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28