weixin_41953741的博客

原始表create table #Sudent(Name varchar(50),AttendDate datetime,AttendCount int)insert into #Sudent values(‘张三’,‘2019-09-01’,2);insert into #Sudent values(‘张三’,‘2019-09-02’,1);insert into #Suden...

初始表(table)数据如下：a sex c1 1 31 0 5select case when sex=‘1’ then ‘男’ else ‘女’ endfrom table

select Round(convert(float,1)/convert(float,3),2)先把整数转换为float ,然后四舍五入