30.有关查詢设计器，正确的描述是： (A)、“联接“选项卡与SQL语句的GROUP BY 短语对应 (B)、“筛选“选项卡与SQL语句的HAVING 短语对应 (C)、“排序依据"选项卡与SQL语句的ORDER BY 短语对应 (D)、"分组依据“ 选项卡与SQL语句的JOIN ON 短语对应

26.有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")

其他試題