摘要：select case when DATEDIFF (minute,GETDATE(), '2018-11-11 00:00:18' )>0 then 0 else 1 end as is_guoqi 阅读全文

摘要：select Round(convert(float,1)/convert(float,3),2) 阅读全文

摘要：已经知道原表year salary------------------ ---------------------2000 10002001 20002002 30002003 4000显示查询结果year salary------------------ ---------------------2000 10002001 30002002 60002003 10000即salary为以前年的工资的和； 我这里提供的答案有两种第一种：select b.year,sum(a.salary) from salary a,salary b where a.year<=b.year group 阅读全文