共找到 2372 与Where 相关的结果，耗时4 ms
执行下列SQL语句SELECT学号，姓名FROM学生WHERE专业号IN(SELSCT专业号FROM专业WHERE专业名=“软件工程”) 则其执行结果中的元组数是A．1B．2C．3D．4
有如下的SOL语句：Ⅰ．SELECT sname FROM s，sc WHERE grade＜60Ⅱ．SELECT sname FROMs WHERE sno IN (SELECT sno FROM sc WHERE grade＜60)Ⅲ．SELECT sname FROM s，sc WHERE
有如下的SQL语句：Ⅰ．SELECT sname FROMs，sc WHERE grade＜60Ⅱ．SELECT sname FROM WHERE sno IN (SELECT sno FROM sc WHERE grade＜60)Ⅲ．SELECT sname FROMs，sc WHERE s.s
A．在FROM予句后加入：WHERE AVG(*)＞85B．在FROM予句后加入：WHERE AVG(Score)＞85C．在GROUP BY子句前加入：HAVING AVG(Score)＞85D．在GROUP BY子句中加入：HAVING AVG(Score)＞85
A．部门号where sum(销售量)＞1000B．部门号having sum(销售量)＞1000C．商品号where sum(销售量)＞100D．商品号having sum(销售量)＞1000
A．WHERE M. 职工号=E. 职工号B．WHEREW M. 职工号=E. 负责人代码C．WHERE M. 部门号=部门号D．WHERE M. 部门号=E. 部门号
A．在FROM子句的下一行加入：WHERE AVG(*)＞85B．在FROM子句的下一行加入：WHERE AVG(Score)＞85C．在GROUP BY子句上一行加入：HAVING AVG(Score)＞85D．在GROUP BY子句下一行加入：HAVING AVG(Score)＞85
A．部门号where sum(数量)＞1000B．部门号having sum(数量)＞1000C．商品号where sum(数量)＞1000D．商品号having sum(数量)＞1000
A．部门号 where sum(销售量)＞1000B．部门号 having Sum(销售量)＞1000C．商品号 where sum(销售量)＞1000D．商品号 having sum(销售量)＞1000
热门搜索：