数据库上机试验报告dk

FROM JSJ86_S140 WHERE (S# IN

(SELECT S#

FROM JSJ86_SC140

WHERE C# = 'CS-02')) AND (SEX = '女')

(2)

SELECT JSJ86_SC140.S#, JSJ86_SC140.GRADE FROM JSJ86_SC140 INNER JOIN

JSJ86_S140 ON JSJ86_SC140.S# = JSJ86_S140.S# WHERE (JSJ86_SC140.S# NOT IN (SELECT S#

FROM JSJ86_SC140

WHERE C# = 'EE-02')) AND (JSJ86_S140.SEX = '男')

(3)

SELECT S#, SNAME, DATEDIFF(YEAR, BDATE, GETDATE()) AS Expr1 FROM JSJ86_S140

WHERE (SEX = '男') AND (HEIGHT >= ANY (SELECT HEIGHT FROM JSJ86_S140

WHERE SNAME = '王涛'))

(4)

SELECT DISTINCT

JSJ86_S140.SNAME, JSJ86_SC140.C#, JSJ86_C140.CREDIT, JSJ86_SC140.GRADE

FROM JSJ86_SC140 INNER JOIN

JSJ86_S140 ON JSJ86_SC140.S# = JSJ86_S140.S# INNER JOIN JSJ86_C140 ON JSJ86_SC140.C# = JSJ86_C140.C#

(5)

SELECT MAX(S#) AS Expr2, MAX(GRADE) AS Expr1 FROM JSJ86_SC140 WHERE (GRADE <>

(SELECT MAX(GRADE) FROM JSJ86_SC140))