9、在SQL的查询语句中，若查询表记录中所有au_id满足前四个字母为“A101”的纪录，则下列正确Where子句是（）
A: Where au_id='A101%'
B: Where au_id = like 'A101%'
C: Where au_id like 'A101%'
D: Where au_id like 'A101？'
A: Where au_id='A101%'
B: Where au_id = like 'A101%'
C: Where au_id like 'A101%'
D: Where au_id like 'A101？'
举一反三
- 在SQL的查询语句中，若查询表记录中所有au_id满足前四个字母为“A101”的纪录，则下列正确Where子句是
- select au_id from authors where state=”ca” or state=”ks”. 下面哪一条语句与这一条语句执行效果相同？ A: select au_id from authors where statenot IN(“ca”,”ks”) B: select au_id from authors where state between ac and sk C: select au_id from authors where state not between ca and ks D: select au_id from authors where state IN(“ca”,”ks”)
- 下面用于查询student表中id值在1,2,3范围内的记录的SQL语句是（ ）。 A: SELECT * FROM student WHERE id=1,2,3; B: SELECT * FROM student WHERE (id=1,id=2,id=3); C: SELECT * FROM student WHERE id in (1,2,3); D: SELECT * FROM student WHERE id in 1,2,3;
- 删除student表中学号为101的记录。其SQL语句为（ ）。 A: DELETE stu where stu_no=101 B: DELETE studnets C: DELETE student WHERE stu_no=101 D: DELETE FROM student WHERE stu_no=101
- 十进制数101的二进制码为（） A: A101 B: B100101 C: C1100101 D: D11100101