mysql> insert into player (id,name,level) values ('238','sagou 轰总',7); mysql> insert into player (id,name,level) values ('795','senoku',15); mysql> insert into player (id,name,level) values ('2460','shirley',1); mysql> insert into player (id,name,level) values ('448',...
select a, b, (case when b=0 then 0 else a/b end) from tabName
51CTO博客已为您找到关于sqlserver中除法保留两位小数点的相关内容,包含IT学习相关文档代码介绍、相关教程视频课程,以及sqlserver中除法保留两位小数点问答内容。更多sqlserver中除法保留两位小数点相关解答可以来51CTO博客参与分享和学习,帮助广大IT技术人实现成长和进步。
select a, b, (case when b=0 then 0 else a/b end) from tabName