abcdefg367的博客

select * from TABLE where id in (select max(id) id from TABLE where year(time)=2016 and month(time)=4 and day(time)=16 group by node having count(node) > 1) order by click desc delete from TA...

sql server 2000中用聚集函数sum()求一列的和时,如:select sum(col003) from 表名,出现了提示:将expression转化为数据类型int时发生算术溢出错误,可是我的col003的数据都在int值的范围之内   解决办法： select sum(cast(col003 as bigint)) from 表名   select sum(conver...