qq_35398459的博客

多个字段分组进行批量删除delete from a_bwhere a in（ select a from a_b where c=0 group by a,b,d having count（a）>1） and id（唯一键） not in( select max(id) from a_b wher...

将datatime属性转换data属性select top 10 COUNT(字段名) count_,CONVERT(varchar(100), time, 23) time from 表名group by CONVERT(varchar(100), time, 23) order by time DESCSELECTCONVERT(varchar(100),GETDATE(),...