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
查询学号为108的同学,同年出生的所有学生的Sno、Sname和Sbirthday列。
create table student(sno int,sname varchar(8),ssex varchar(8),sbirthday datetime,class varchar(8))
insert student
select '108','曾华','男','1905-05-22','95033' union all
select '105','匡明','男','1905-05-18','95031' union all
select '107','王丽','女','1905-05-07','95033' union all
select '101','李军','女','1905-05-09','95033' union all
select '109','王芳','女','1905-05-18','95031' union all
select '103','陆君','男','1905-05-20','95031'
select sno,t.Sname,t.Sbirthday from student,(select Sname,Sbirthday from student)t where datediff(yy,t.Sbirthday,Sbirthday)=0 and sno='108'
等F姐姐跟77哥进来解答
SQL code:
--> 测试数据：[tb]
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]
sel
