下面SQL语句中,用于删除user表中id大于5的记录的语句是
A: DELETEFROMuserwhereid>5;
B: DELETEFROMusersetid>5;
C: DELETEuserwhereid>5;
D: DELETEusersetid>5;
A: DELETEFROMuserwhereid>5;
B: DELETEFROMusersetid>5;
C: DELETEuserwhereid>5;
D: DELETEusersetid>5;
举一反三
- 下面SQL语句中，用于删除user表中id大于5的记录的语句是
- 用SQL语句逻辑删除xsqk表中记录号为5的记录,实现语句为() A: delete record5 B: delete next 5 C: delete fromxsqk whererecno()=5 D: deletefrom xsqkwhere record 5
- 下面选项中，查询student表中id值不在2和5之间的SQL语句是（）
- 将表new_goods中删除id>5的记录
- 下面选项中，查询student表中id值不在2和5之间的SQL语句是（ ）。 A: SELECT * FROM `student` WHERE `id`!=2,3,4,5 B: SELECT * FROM `student` WHERE `id` NOT BETWEEN 5 AND 2 C: SELECT * FROM `student` WHERE `id` NOT BETWEEN 2 AND 5 D: SELECT * FROM `student` WHERE `id` NOT IN 2,3,4,5