拼接字符串,distinct就不能拼前面?我放在前面有点问题,能给提供下代码吗? 放不到前面去,放到前面语意就有问题 select @mailto=@mailto+';' + (email) FROM(SELECT distinct email FROM a)b select @mailto=@mailto+';' + email from (select distinct email from a) b where b.name in (select name from #subregiongm) 这样写对吗?
不对 select @mailto=@mailto+';' + email from (select distinct email from a where a.name in (select name from #subregiongm)) b 应该这样
select Top 1 @xx=xx from tb where A='xx'
放不到前面去,放到前面语意就有问题
select @mailto=@mailto+';' + (email) FROM(SELECT distinct email FROM a)b
放不到前面去,放到前面语意就有问题
select @mailto=@mailto+';' + (email) FROM(SELECT distinct email FROM a)b select @mailto=@mailto+';' + email from (select distinct email from a) b where b.name in (select name from #subregiongm) 这样写对吗?
select @mailto=@mailto+';' + email from (select distinct email from a where a.name in (select name from #subregiongm)) b
应该这样