相关考题
-
单项选择题
你需要修改STUDENTS 表在STUDENT_ID列上增加一个PK约束,当前此表为空表,下面语句正确的是()
A.ALTER TABLE students ADD PRIMARY KEY student_id
B.ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id)
C.ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id
D.ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id) -
单项选择题
在SELECT语句中用于实现条件选择运算的关键字是()
A.FOR
B.WHILE
C.WHERE
D.CONDITION -
单项选择题
要想对表中记录分组查询,可以使用哪一子句()
A.GROUP BY
B.AS GROUP
C.GROUP AS
D.TO GROUP