114.View the Exhibit and examine the structure of the SALES table.
The following query is written to retrieve all those product ID s from the SALES table that have more than
55000 sold and have been ordered more than 10 times.
SQL> SELECT prod_id FROM sales
WHERE quantity_sold > 55000 AND COUNT(*)>10
GROUP BY prod_id
HAVING COUNT(*)>10;
Which statement is true regarding this SQL statement?
A.It executes successfully and generates the required result.
B.It produces an error because COUNT(*) should be specified in the SELECT clause also.
C.It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE clause.
D.It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*).
答案:C
解析:count 这种聚合函数不能直接用在where语句中,要不就是整体的sql,要不就用在having中
The following query is written to retrieve all those product ID s from the SALES table that have more than
55000 sold and have been ordered more than 10 times.
SQL> SELECT prod_id FROM sales
WHERE quantity_sold > 55000 AND COUNT(*)>10
GROUP BY prod_id
HAVING COUNT(*)>10;
Which statement is true regarding this SQL statement?
A.It executes successfully and generates the required result.
B.It produces an error because COUNT(*) should be specified in the SELECT clause also.
C.It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE clause.
D.It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*).
答案:C
解析:count 这种聚合函数不能直接用在where语句中,要不就是整体的sql,要不就用在having中