下面删除记录的语句正确的是( )
A: delete from emp where name="Tony";
B: delete * from emp where name="Tony";
C: drop from emp where name="Tony";
D: drop * from emp where name="Tony";
A: delete from emp where name="Tony";
B: delete * from emp where name="Tony";
C: drop from emp where name="Tony";
D: drop * from emp where name="Tony";
举一反三
- 以下能删除表的语句是( ) A: Delete * from emp B: Drop database emp C: Drop * from emp D: delete database emp
- 从表R中删除所有姓"李"的学生记录，其中NAME表示学生姓名，下列语句中正确的是（）。 A: DELETE FROM R WHRER NAME LIKE'李%' B: DELETE ALL FROM R WHERE NAME='李' C: DELETE WHERE NAME='李' D: REVOKE ALL FROM R WHERE NAME LIKE'李'
- 查询员工表emp中的第3条到第8条记录。显示emp表中的全部字段。( ) A: select rownum rn,emp.* from emp where rownum3; B: select * from(select rownum RN,emp.* from emp where RN3; C: select * from(select rownum RN,emp.* from emp where rownum3; D: select rownum RN,emp.* from emp where RN3;
- 删除表teacher(id,name,gender,birthday,score)中id为4的老师( ) A: delete from teacher; B: delete from teacher where id = 4; C: delete teacher where id = 4; D: drop from teacher where id = 4;
- Where did Tony come from?