yaer函数的用法(查询学号为108的同学,同年出生的所有学生的Sno、Sname和Sbirthday列)

if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([sno] int,[sname] varchar(4),[ssex] varchar(2),[sbirthday] datetime,[class] int)
insert [tb]
select 108,'曾华','男','1905-05-22 00:00:00.000',95033 union all
select 105,'匡明','男','1905-05-18 00:00:00.000',95031 union all
select 107,'王丽','女','1905-05-07 00:00:00.000',95033 union all
select 101,'李军','男','1905-05-09 00:00:00.000',95033 union all
select 109,'王芳','女','1905-05-18 00:00:00.000',95031 union all
select 103,'陆君','男','1905-05-20 00:00:00.000',95031

--------------------------------查询开始------------------------------

select * from [tb] where year(sbirthday)=(select year(sbirthday) from tb where [sno]=108)
/*
sno         sname ssex sbirthday               class
----------- ----- ---- ----------------------- -----------
108         曾华    男    1905-05-22 00:00:00.000 95033
105         匡明    男    1905-05-18 00:00:00.000 95031
107         王丽    女    1905-05-07 00:00:00.000 95033
101         李军    男    1905-05-09 00:00:00.000 95033
109         王芳    女    1905-05-18 00:00:00.000 95031
103         陆君    男    1905-05-20 00:00:00.000 95031

(6 行受影响)


*/