![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
yueyue__
这个作者很懒,什么都没留下…
展开
-
sqlserver Sum求和float类型 数据不准问题
转换类型为decimal:SUM(cast(VideotapeLong as decimal(18,1)))原创 2021-10-15 09:57:34 · 1179 阅读 · 0 评论 -
sql server 计算数据库时间差
SELECT datediff(yy,'2010-06-1 10:10',GETDATE()) --计算多少年SELECT datediff(q,'2011-01-1 10:10',GETDATE()) --计算多少季度 3个月一个季度SELECT datediff(mm,'2011-06-1 10:10',GETDATE()) --计算多少月SELECT datediff(dd,'2011-06-1 10:10',GETDATE()) --计算多少天SELECT datediff(wk,'201原创 2021-09-18 15:02:13 · 1063 阅读 · 0 评论 -
查询概率的sql语句
select aaa.name as '乡镇',count(aa) as '总数',sum(aa) as '完整数', Convert(decimal(18,2), (sum(aa)+0.0)/count(aa)*100) as '完整率(%)' from ( select dp.Name, --Convert(decimal(18,2), --sum( case when ( WorkUnit is not null and WorkUnit!='' )then 1 els原创 2021-09-18 14:57:13 · 311 阅读 · 0 评论 -
mysql除法取整
select floor(100 / 1.7)原创 2021-09-01 17:20:31 · 5113 阅读 · 0 评论 -
SQL常用语句
Select Name,ID From A group by Name,ID having count (*)>1原创 2021-06-17 14:37:24 · 44 阅读 · 0 评论