EMPテーブルの次の説明を調べます。 次のクエリを実行します。 SELECT deptno AS "departments"、SUM(sal)AS "salary" 従業員から グループ| 1まで HAVING SUM(sal)> 3 000; 結果はどうなりますか?
正解:C
The query uses the syntax GROUP | BY 1 which is not correct. The pipe symbol | is not a valid character in the context of the GROUP BY clause. Additionally, when using GROUP BY with a number, it refers to the position of the column in the SELECT list, which should be written without a pipe symbol and correctly as GROUP BY 1. Since the syntax is incorrect, the database engine will return an error.