查询课程名称以“计算机”开头的记录的准则是( )。
A.In“计算机”
B.Not“计算机*”
C.Like“计算机*”
D.Mid“计算机”
第1题:
在课程表中要查找课程名称中包含“计算机”的课程,对应“课程名称”字段的正确准则表达式是______。
A.计算机
B.*计算机*“
C.Like"*计算机,"
D.Like"计算机"
第2题:
要查询book表中所有书名中以“计算机”开头的书籍的价格,可用()语句
A.SELECT price FROM book WHERE book_name = ‘计算机*’
B.SELECT price FROM book WHERE book_name LIKE ‘计算机*’
C.SELECT price FROM book WHERE book_name = ‘计算机%’
D.SELECT price FROM book WHERE book_name LIKE ‘计算机%’
第3题:
要查询book表中所有书名中以“计算机”开头的书籍的价格,可用______语句。()
A.SELECT price FROM book WHERE book_name =‘计算机*’
B.SELECT price FROM book WHERE book_name LIKE‘计算机*’
C.SELECT price FROM book WHERE book_name =‘计算机%’
D.SELECT price FROM book WHERE book_name LIKE‘计算机%’
第4题:
要查询book表中书名book中以“计算机”开头的书籍的价格,可用()语句
A.select price from book where name = ‘计算机*’
B.select price from book where name like ‘计算机*’
C.select price from book where name = ‘计算机%’
D.select price from book where name like ‘计算机%’
第5题:
2、要查询book表中所有书名中以“计算机”开头的书籍的价格,可用()语句
A.SELECT price FROM book WHERE book_name = ‘计算机*’
B.SELECT price FROM book WHERE book_name LIKE ‘计算机*’
C.SELECT price FROM book WHERE book_name = ‘计算机%’
D.SELECT price FROM book WHERE book_name LIKE ‘计算机%’