sql
榴莲小蛋糕儿
这个作者很懒,什么都没留下…
展开
-
sql: 查询某字段被包含在字符串中
sql: 查询某字段被包含在字符串中原创 2022-10-12 15:19:27 · 2440 阅读 · 1 评论 -
java 和sql 实现double小数位精确
round(AVG(a.amount), 3) as "amount",round(AVG(a.quality), 3) as "quality",round(AVG(a.quality_test), 3) as "quality_test",round(AVG(a.timely_delivery), 3) as "timely_delivery",round(AVG(a.pack), 3) as "pack",round(AVG(a.identify), 3) as "identi.原创 2020-08-13 17:06:18 · 707 阅读 · 0 评论 -
sql 求和并且将求和条件作为查询条件
上代码查询某张表中多批物资的库存数,并且要求库存数>0SELECT operation_warehouse,mat_id,mat_num,specification_type,mat_type,unit,sum(stock_num) as tt,sum(balance_num),sum(occupy_num)FROM `ws_mat_stock`GROUP BY operation_warehouse,mat_id,mat_num,specification_type,mat_ty原创 2020-07-06 23:27:40 · 3057 阅读 · 1 评论