设数据表XS.DBF中有学号(C)字段,逻辑删除学号中以“2015”开头的记录,正确的SQL语句是________.
A: DELETE FROM XS WHERE “2015”$学号
B: DELETE FROM XS WHERE LEFT(学号，4)==”2015”
C: DELETE FROM XS FOR “2015”$学号
D: DELETE FROM XS FOR LEFT(学号，4)==”2015”
A: DELETE FROM XS WHERE “2015”$学号
B: DELETE FROM XS WHERE LEFT(学号，4)==”2015”
C: DELETE FROM XS FOR “2015”$学号
D: DELETE FROM XS FOR LEFT(学号，4)==”2015”
举一反三
- 设“学生”表中有 “学号”等字段,删除学号为“S01002”的学生的记录,正确的SQL语句是( )。 A: DELETE 学号="S01002" B: DELETE FROM 学号="S01002" C: DELETE 学号="S01002" FROM 学生 D: DELETE FROM 学生 WHERE 学号="S01002"
- 设“学生”表中有 “学号”等字段，删除学号为“S01002”的学生的记录，正确的SQL语句是（ ）。 A: DELETE 学号="S01002" B: DELETE FROM 学号="S01002" C: DELETE 学号="S01002" FROM 学生 D: DELETE FROM 学生 WHERE 学号="S01002"
- 设数据表XS.DBF中有学号(C)字段,逻辑删除学号中以“2015”开头的记录,可以使用SQL语句
- 从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DELETE FROM 学生 WHERE 学号="1001" B: DROP FROM 学生 FOR 学号="1001" C: DROP FROM 学生 WHERE 学号="1001" D: DELETE FROM 学生 FOR 学号="1001"
- 从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DROP FROM Student WHERE 学号="1001" B: DROP FROM Student FOR 学号="1001" C: DELETE FROM Student WHERE 学号="1001" D: DELETE FROM Student FOR 学号="1001"