mysql - 重写 Excel 公式以在 mySQL 中运行
问题描述
在 Excel 中,我有这个公式来计算价格,将其标记为 1.5%,然后将其四舍五入到下一个 10 美元:
=ROUNDUP(SUM(A2*1.015),-1)
如果可能的话,我想在 MySQL 中做同样的事情
解决方案
你可以这样做:
SELECT CEIL(150.37*1.015);
您的最终查询必须如下所示:
SELECT CEIL(PRICEFIELD*1.015) AS Price FROM YourTable;
推荐阅读
- azure-cognitive-search - Indexing html - token lenghts and highlights
- flutter - Flutter web Vrouter routing navigate back but path getting erased automatically?
- reactjs - Attempted import error: 'CSmartTable' is not exported from '@coreui/react'
- angular - Highcharts 没有从 Angular 中的 API 调用打印点
- sql - Alternative for case when statement that is not mutually exclsuive
- javascript - Taiko/Gauge - The Header Basic Authorization is getting mixed with the form Login
- twilio - Caption support for Twilio Programmable Video
- filter - InfluxDb: how to fix abnormal value caused by missing data after difference transformation
- spring-boot - EventHandler in external java file not getting triggered
- wordpress - Wordpress Meta Query using Custom Field