A.research
B.a research
C.researches
D.the researches
第1题:
有SQL语句: SELECTDISTINCT系号FROM教师WHERE工资>=; ALL(SELECT工资FROM教师WHERE系号="02") 与如上语句等价的SQL语句是
A.SELECTDISTINCT系号FROM教师WHERE工资>=; (SELECTMAX(工资)FROM教师WHERE系号="02")
B.SELECTDISTINCT系号FROM教师WHERE工资>=; (SELECTMIN(工资)FROM教师WHERE系号="02")
C.ELECTDISTINCT系号FROM教师WHERE工资>=; ANY(SELECT工资FROM教师WHERE系号="02")
D.SELECTDISTINCT系号FROM教师WHERE工资>=; SOME(SELECT工资FROM教师WHERE系号="02")
第2题:
第3题:
邮件首部是由系统自动生成的发信人地址(From:)、邮件发送的日期与时间、收信人地址(To:)、抄送人地址(Cc:)与邮件主题(Subject:)等。
第4题:
有SQL语句:SELECT DISTINCT系号FROM教师WHERE 工资>=ALL (SELECT 工资FROM教师WHERE系号=\"02\") 与如上语句等价的SQL语句是
A.SELECT DISTINCT系号FROM教师WHERE工资>=(SELECT MAX(工资)FROM教师WHERE 系号="02")
B.SELECT DISTINCT系号FROM教师WHERE工资>=(SELECT MIN(工资)FROM教师WHERE 系号="02")
C.SELECT DISTINCT系号FROM教师WHERE工资>=(ANY(SELECT(工资)FROM教师WHERE 系号="02")
D.SELECT DISTINCT系号FROM教师WHERE工资>=(SOME (SELECT(工资)FROM教师WHERE 系号="02")
第5题:
第6题:
查询各科成绩前三名的记录 SELECT * FROM(SELECT *, RANK() OVER (PARTITION BY sc.CId ORDER BY sc.score) as r FROM sc) as A WHERE A.r <= 3