select * from (select datediff(year,qs,getdate())as age from tb_wy) t where t.age >= 30 and t.age <= 45
select * from t where datediff(year,qs,getdate()) >= 30 and datediff(year,qs,getdate()) <= 45 --Orselect * from t where datediff(year,qs,getdate()) Between 30 and 45
select name,datediff(year,qs,getdate()) as age from tb_wy where datediff(year,qs,getdate()) between 30 and 45
select * from tb_wy where datediff(year,qs,getdate())between 30 and 45 这样简单 快一点
select *
from (select datediff(year,qs,getdate())as age from tb_wy) t
where t.age >= 30 and t.age <= 45
from t
where datediff(year,qs,getdate()) >= 30 and datediff(year,qs,getdate()) <= 45
--Orselect *
from t
where datediff(year,qs,getdate()) Between 30 and 45
这样简单 快一点