发布时间 : 星期六 文章数据库上机试验报告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))