select count(*) from (select distinct UC_FileHash from tbl_HashSortInfo1 as temp) temp
使用distinct去除重复,统计某一个字段值出现的个数
IF EXISTS (SELECT * FROM tbl_UploadContent_tmp WHERE ID=888) BEGIN update tbl_UploadContent_tmp set UC_userid=111 where ID=888 END ELSE BEGIN insert into tbl_UploadContent_tmp (code,UC_userid) values (1,222) END
如果存在则执行update,如果不存在则执行insert;sqlserver下只能这么干,在mysql下面有replace语句可以实现此功能
select top 5 UC_MusicHash,(case (select count(*) from tbl_HashSortInfo1 where UC_FileHash=UC_MusicHash) when 0 then 0 else 1 end) from tbl_UploadContent_tmp
case when相当于c语言中的switch case语句。
select month(UC_UploadTime) as 月份, count(*) as 总量 from tbl_UploadContent where year(UC_UploadTime)=2013 group by month(UC_UploadTime)
按月统计