select 500 / (501) *100
结果为0,由于数值是INT类型,怎么才能得到小数点呢?
select 500 / (501 + 0.0) *100
99.800300这样就有小数点了。。。天那。。SQL真是有点笨。
Copyright @ 2025 Yanyyx Powered by .NET 9.0 on Kubernetes Powered by: .Text and ASP.NET Theme by: .NET Monster