下面选项中,用于将表student中字段grade值更新为80的SQL语句是
A: ALTERTABLEstudentsetgrade=80;
B: UPDATEstudentsetgrade=80wheregrade=80;
C: UPDATEstudentsetgrade=80wheregrade<=80;
D: UPDATEstudentsetgrade=80;
A: ALTERTABLEstudentsetgrade=80;
B: UPDATEstudentsetgrade=80wheregrade=80;
C: UPDATEstudentsetgrade=80wheregrade<=80;
D: UPDATEstudentsetgrade=80;
举一反三
- 下面选项中，用于将表student中字段grade值更新为80的SQL语句是( ) A: ALTER TABLE student set grade=80; B: UPDATE student set grade=80 where grade=80; C: UPDATE student set grade=80 where grade<=80; D: UPDATE student set grade=80;
- 下列选项中,用于将student 表中“grade " 字段的值修改为“80”的SQL 语句是( )。 A: ALTER TABLE student set grade=80; B: ALTER student set grade=80; C: UPDATE student set grade=80 where grade<;80; D: UPDATE student set grade=80;
- 下面选项中，用于将表student中字段grade值更新为80的SQL语句是
- 下面选项中,能够更新表student中id值小于4的SQL语句是 A: ALTERTABLEstudentwhereid<4; B: UPDATEstudentsetgrade=100whereid<4; C: UPDATEstudentsetgrade=100whereid<=4; D: UPDATETablestudentsetgrade=100whereid<4;
- 已知有关系“STUDENT”，则关系运算σANE＜80(STUDENT)用SQL语句表示为 (52) 。 A: SELECT( * )FROM STUDENT WHERE AVE ＜ 80 B: SELECT( * ) FROM STUDENT HAVING AVE ＜ 80 C: SELECT(AVE) FROM STUDENT WHERE AVE ＜ 80 D: SELECT(AVE） FROM STUDENT HAVING AVE ＜ 80