select name from (select name from tb where time between '2005-01-01' and '2006-01-01' group by name) as b left join (select name from tb where time between '2004-01-01' and '2005-01-01' group by name) as a on b.name=a.name where a.name is null不知道行不行,试一下,效率也不知道怎么样
(select name from tb where time between '2004-01-01' and '2005-01-01' group by name) as a on b.name=a.name where a.name is null不知道行不行,试一下,效率也不知道怎么样