小数转换成整数的函数ceil:
select left(FTime,10) as Time,ceil(count(*)/2) from Tbl_UserInvite_XX where FFlag=1 group by left(FTime,10);
select left(FTime,10) as Time,ceil(count(*)/2) from Tbl_UserInvite_XX where FFlag=1 group by left(FTime,10);
作者:jackxiang@向东博客 专注WEB应用 构架之美 --- 构架之美,在于尽态极妍 | 应用之美,在于药到病除
地址:http://jackxiang.com/post/4197/
版权所有。转载时必须以链接形式注明作者和原始出处及本声明!
评论列表