下列的SQL语句中可以正确执行的是 A)INSERT INTO STUDENT VALUES（'1031','王小平',

答案:1 悬赏:30

解决时间 2021-01-12 14:29

提问者网友：遁入空寂
2021-01-12 06:36

最佳答案

二级知识专家网友：刀戟声无边
2021-01-12 08:08

这个我本地Oracle跑了一下，语法错误啊.CREATE TABLE test_DISTINCT ( a INT, b INT, c INT, d INT);INSERT INTO test_DISTINCT VALUES( 0, 0, 0, 0);INSERT INTO test_DISTINCT VALUES( 0, 0, 0, 1);INSERT INTO test_DISTINCT VALUES( 0, 0, 1, 0);INSERT INTO test_DISTINCT VALUES( 0, 0, 1, 1);INSERT INTO test_DISTINCT VALUES( 0, 1, 0, 0);INSERT INTO test_DISTINCT VALUES( 0, 1, 0, 1);INSERT INTO test_DISTINCT VALUES( 0, 1, 1, 0);INSERT INTO test_DISTINCT VALUES( 0, 1, 1, 1);INSERT INTO test_DISTINCT VALUES( 1, 0, 0, 0);INSERT INTO test_DISTINCT VALUES( 1, 0, 0, 1);INSERT INTO test_DISTINCT VALUES( 1, 0, 1, 0);INSERT INTO test_DISTINCT VALUES( 1, 0, 1, 1);INSERT INTO test_DISTINCT VALUES( 1, 1, 0, 0);INSERT INTO test_DISTINCT VALUES( 1, 1, 0, 1);INSERT INTO test_DISTINCT VALUES( 1, 1, 1, 0);INSERT INTO test_DISTINCT VALUES( 1, 1, 1, 1);SQL> SELECt DISTINCT a,b,c,d FROM test_DISTINCT; A B C D---------- ---------- ---------- ---------- 1 0 1 0 1 0 1 1 1 1 0 1 1 1 1 1 0 0 1 1 0 0 0 1 0 0 1 0 1 0 0 1 1 1 1 0 0 1 0 1 0 1 1 0 A B C D---------- ---------- ---------- ---------- 1 0 0 0 1 1 0 0 0 0 0 0 0 1 0 0 0 1 1 1已选择16行。SQL> SELECt a, DISTINCT b,c,d FROM test_DISTINCT;SELECt a, DISTINCT b,c,d FROM test_DISTINCT *ERROR 位于第 1 行:ORA-00936: 缺失表达式

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息！