2015年8月17日

having count group by

摘要: select count(*) from (select field2,count(field2) from bsgj.table1 group by field,items_id having(count(field2)>1)) as tmpwhere field2=43月份以来下单超过两单的收货... 阅读全文

posted @ 2015-08-17 16:41 walter371 阅读(190) 评论(0) 推荐(0) 编辑

mysql TRUNCATE

摘要: 保留小数点select truncate(field1,2) from table1field3 字段类型为decimal(20,3) 阅读全文

posted @ 2015-08-17 16:21 walter371 阅读(187) 评论(0) 推荐(0) 编辑

导航