摘要:
--1、distinct 去重关键字 【用法:查询字段前面】Push_EmailLog :记录表 select distinct UserName from Push_EmailLog --2、分组排序 ROW_NUMBER()OVER(PARTITION BY 字段1 ORDER BY 字段2 d 阅读全文
摘要:
--查询近7天数据记录行数,没有返回0 select a.click_date,ISNULL(b.count,0) as countfrom ( SELECT convert(varchar(10),getdate()-7,120) as click_date union all SELECT co 阅读全文