【正文】
,name,score FROM student,score WHERE *= AND =39。)) 2 SELECT name,age FROM student WHERE age ANY (SELECT age FROM student WHERE name=39。) 2 SELECT name FROM student WHERE EXISTS (SELECT * FROM score WHERE =sno AND o=39。 UNION SELECT name,major,gender FROM student WHERE major=39。 GO EXEC student_male(2)EXEC sp_helptext student_male(3)DROP PROC student_male USE 教學(xué) GO CREATE PROC student_male (gender char(2)= 39。第七章1.(1)USE 教學(xué) GO CREATE PROC student_male AS SELECT * FROM student WHERE gender= 39。2 SELECT name,major,gender FROM student WHERE gender=39。) 或 SELECT name,age FROM student WHERE age (SELECT MAX(age) FROM student WHERE major=39?;?