select sno,age=.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 10 行

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