SQL server数据库
select
row_number() over(partition by datepart(DAY,date) order by date)
from tbl,date
where
(convert(varchar,date,120) like '2015-11-13%'
or convert(varchar,date,120) like '2015-11-14%')
group by date
请问2015-11-13日期有记录,2015-11-14无记录的情况下,怎么能给2015-11-14日期给一个null