一条简单的SQL语句，那为英雄帮我写一下

Question

select cast(year(GetDate())-year(birthday) as varchar(4))+'岁' as 'show',count(*) as 'div' from t_Teachers 
group by year(Birthday)

Answer 1

select cast(datediff(year,birthday,getdate()) as varchar(4))+'岁' as 'show',
count(*) as 'vid' from t_teachers 
group by cast(datediff(year,birthday,getdate()) as varchar(4))+'岁'

Answer 2

或：
select cast(year(GetDate())-year(birthday) as varchar(4))+'岁' as 'show',count(*) as 'div' from t_Teachers 
group by cast(year(GetDate())-year(birthday) as varchar(4))+'岁'

Answer 3

select datediff(year,Birtyday,getdate()) + case when dateadd(year,datediff(year,Birtyday,getdate()),Birtyday) <= getdate() then 1 else 0
,count(*)
from t_Teachers
datediff(year,Birtyday,getdate()) + case when dateadd(year,datediff(year,Birtyday,getdate()),Birtyday) <= getdate() then 1 else 0

Answer 4

select cast(year(GetDate())-year(birthday) as varchar(4))+'岁' as 'show',count(*) as 'div' from t_Teachers group by year(Birthday)//////////

Answer 5

select datediff(year,Birtyday,getdate()) + case when dateadd(year,datediff(year,Birtyday,getdate()),Birtyday) <= getdate() then 1 else 0 end
,count(*)
from t_Teachers
group by datediff(year,Birtyday,getdate()) + case when dateadd(year,datediff(year,Birtyday,getdate()),Birtyday) <= getdate() then 1 else 0 end

Answer 6

select cast(datediff(yy,birthday,getdate()) as varchar) + '岁' as 'show',count(*) as 'div' 
from t_Teachers 
group by datediff(yy,birthday,getdate()

Answer 7

select cast(year(GetDate())-year(birthday) as varchar(4))+'岁' as 'show',count(*) as 'div' from t_Teachers group by cast(year(GetDate())-year(birthday) as varchar(4))+'岁'

Answer 8

select cast(year(GetDate())-year(birthday) as varchar(4))+'岁' as 'show',count(*) as 'div' from t_Teachers 
group by year(Birthday)