-- 是这个意思吗? SELECT '2015-02-28' as startdate,DATEADD(DAY, 2, '2015-02-28') as addDayDate FROM t_agreement a LEFT JOIN t_agreement_project ap ON a.id = ap.agreement_id
我要group by , 去掉重复的。
这两列数据,都从哪里来? 你的好像都是常量来的你可以替换成你的字段, -- 大概如下SELECT distinct '2015-02-28' as startdate,DATEADD(colname, 2, '2015-02-28') as addDayDate FROM t_agreement a LEFT JOIN t_agreement_project ap ON a.id = ap.agreement_id
-- 是这个意思吗?
SELECT '2015-02-28' as startdate,DATEADD(DAY, 2, '2015-02-28') as addDayDate
FROM t_agreement a
LEFT JOIN t_agreement_project ap ON a.id = ap.agreement_id
我要group by , 去掉重复的。
-- 大概如下SELECT distinct '2015-02-28' as startdate,DATEADD(colname, 2, '2015-02-28') as addDayDate
FROM t_agreement a
LEFT JOIN t_agreement_project ap ON a.id = ap.agreement_id