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 行受影响)
*/