select sno,age=.sql

在学习SQL Server过程中整理的T-SQL语句

use test
select sno,age=
           case
               when datediff(year,[birth time],getdate())<=22 then '年龄较小'
               when datediff(year,[birth time],getdate())<28 and datediff(year,[birth time],getdate())>22 then '年龄适中'
               when datediff(year,[birth time],getdate())>=28 then '年龄偏大'
               else '不详'
           end
        from XS
go