请教一个数据库的题目:

显示全部楼层 · 2011-9-13 11:48:10

1. select distinct 姓名 from S where 系名='计算机'2.select distinct 姓名,系名 from S where 年龄< 18 and性别 ='男'3.select distinct S.姓名 from S ,X,C where X.学号 = S.学号 and X.课程号 =C.课程号 and C.课程名='数据库技术'4.select distinct C.课程名 from S ,X,C where X.学号 = S.学号 and X.课程号 =C.课程号 and S.姓名='李小明'5.select distinct S.姓名 from S ,X,C where X.学号 = S.学...

千问 · 2011-9-13 11:48:10

(1). select * from ~~where [学号] in (select [学号] from [x] where [课程号] in (select [课程号] from [c] where [课程名]=‘计算机’))...~~